Start with a datetime field. Set it to the date you need. Copy this field to a char field. Use the weekadd function on the datetime field. Use a goto action and repeat if necessary. Good luck, michiel.
2007/9/21, Oza, Veeral <[EMAIL PROTECTED]>: > Hi All, > > I have been struggling with issue from quite a few days. > I dont want to read any data from any form. My SQL Query is dynamic. It does > not pull data from any table. > > Select distinct DATEADD(wk, DATEDIFF(wk,0,DATEADD(day, z.num, > '2007/09/18')), 0) firstDayOfWeek > FROM ( SELECT b10.i + b9.i + b8.i + b7.i + b6.i + b5.i + b4.i + b3.i + b2.i > + b1.i + b0.i num > FROM (SELECT 0 i UNION ALL SELECT 1) b0 > CROSS JOIN (SELECT 0 i UNION ALL SELECT 2) b1 > CROSS JOIN (SELECT 0 i UNION ALL SELECT 4) b2 > CROSS JOIN (SELECT 0 i UNION ALL SELECT 8) b3 > CROSS JOIN (SELECT 0 i UNION ALL SELECT 16) b4 > CROSS JOIN (SELECT 0 i UNION ALL SELECT 32) b5 > CROSS JOIN (SELECT 0 i UNION ALL SELECT 64) b6 > CROSS JOIN (SELECT 0 i UNION ALL SELECT 128) b7 > CROSS JOIN (SELECT 0 i UNION ALL SELECT 256) b8 > CROSS JOIN (SELECT 0 i UNION ALL SELECT 512) b9 > CROSS JOIN (SELECT 0 i UNION ALL SELECT 1024) b10 > ) z WHERE z.num <= DATEDIFF(day, '2007/09/18', '2007/10/18') > > Result: > 2007-09-17 00:00:00.000 > 2007-09-24 00:00:00.000 > 2007-10-01 00:00:00.000 > 2007-10-08 00:00:00.000 > 2007-10-15 00:00:00.000 > > I tried to do this in SQL itself so that it returns me a single row of a > comma seperated values, but i was not able to do that. > I need this result > 2007-09-17 00:00:00.000 > 2007-09-24 00:00:00.000 > 2007-10-01 00:00:00.000 > 2007-10-08 00:00:00.000 > 2007-10-15 00:00:00.000 > in a table field > > OR > > 2007-09-17 00:00:00.000, 2007-09-24 00:00:00.000, 2007-10-01 00:00:00.000, > 2007-10-08 00:00:00.000, 2007-10-15 00:00:00.000 > in a char field. > > Environment: > ITSM 7.0.1 > SQL Server 2000 > Windows 2003 server. > > Please help me to resolve this one. > > Regards, > Veeral Oza, > Application Developer, > Column Technologies, > Cell: 224-587-0765 > Desk: 847-632-3327 > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the > Answers Are" > -- Met vriendelijke groet / Kind regards Michiel Beijen ______________________________________________________ MANSOLUTIONS Energieweg 60-62 3771 NA Barneveld The Netherlands Tel. +31-(0)612968592 Mail [EMAIL PROTECTED] Internet http://bsm.mansolutions.nl _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
