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.
| Author |
Topic |
|
learntsql
524 Posts |
 Posted - 2009-12-09 : 05:55:16
|
| Hi...I have to generate the weeks dynamically as followslets say @today='09-Dec-2009'then my output should be as Wed-Sat || Sun-Sat || Sun-Sat ||...(specific times)09Dec-12Dec 13Dec-19Dec 20Dec-26Dec....... |
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2009-12-09 : 15:39:27
|
Please clarify.
Success is 10% Intelligence, 70% Determination, and 22% Stupidity.\_/ _/ _/\_/ _/\_/ _/ _/- 881 |
 |
|
|
learntsql
524 Posts |
Posted - 2009-12-10 : 00:10:31
|
| Wed-Sat || Sun-Sat || Sun-Sat || Sun-Sat 09Dec-12Dec||13Dec-19Dec||20Dec-26Dec||27-Dec-03-JanThis is my output format.the above shown is column header and i will show details under each column. |
|
|
|
|
|
|
Datetime functions help