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.
Johnph Posting Yak Master
103 Posts
James K Master Smack Fu Yak Hacker
3873 Posts
CASE yourVarcharCol WHEN '1' THEN 'January' WHEN '2' THEN 'February' --- etcEND AS MonthName;
DATENAME(month,DATEADD(mm,CAST(@yourcol AS INT)-1,0))
SQLTeam.com Articles via RSS
SQLTeam.com Weblog via RSS
- Advertisement -
Articles
Forums
Blogs
Contact Us
About the Site