Friday, June 20, 2008

query for Select current week values from table in sql server 2000

SELECT * FROM test_test where c_date Between (SELECT (DATEADD(wk, DATEDIFF(wk,0,GETDATE()), 0))) AND(SELECT DATEADD(wk, DATEDIFF(wk,0,GETDATE()), 6))
Posted by at

2 comments:

RD said...

Thank's Prabhat
I got the code for my project.

June 26, 2008 at 9:00 PM
Unknown said...

Thank you dear !!!!!!

September 28, 2008 at 6:52 AM

Post a Comment

Subscribe to: Post Comments (Atom)