Month, Week No, Date with matrix format

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Month, Week No, Date with matrix format

Author

Topic

shankumaran1983
Starting Member

1 Post

Posted - 2009-06-18 : 01:55:34

Hai

I need to display month, week no, week start dt, week end dt, and then week day, then value for that week day from a table. Like,

1st week 2nd week 3rd week 4th week 5th week
June 01-07 08-14 15-21 22-28 29-30
1,00.00 1,120.00 1,124.00 1,11.00 2,215.00
July 01-07 08-14 15-21 22-28 29-30
0 1,120.00 0 1,11.00 2,215.00
Aug 01-07 08-14 15-21 22-28 29-30
1,00.00 1,120.00 1,124.00 1,11.00 2,215.00
Sep 01-07 08-14 15-21 22-28 29-30
0 1,120.00 0 1,11.00 2,215.00

pls help to solve above

Thanks n Regards
Senthilkumar Shanmugam

senthlkumar shanmugam

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-06-18 : 10:00:20

can you post the table DDL and sample data that give the required result that you posted ?

KH
[spoiler]Time is always against us[/spoiler]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources