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 |
|
sql_er
Constraint Violating Yak Guru
267 Posts |
 Posted - 2013-03-21 : 12:07:19
|
| Hi guys,Did anyone ever have to create a function/stored procedure that would take a date as an input and generate the values for the broadcast calender like:- Media_Week_Start_Date- Media_Week- Media_Month- Media_MonthName- Media_Quarter- Media_YearThanks in advance! |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2013-03-21 : 12:42:53
|
| Datepart() will be your friend. |
 |
|
|
|
|
|
Broadcast calender generator