Skip to content

Instantly share code, notes, and snippets.

@troyscott

troyscott/2010-07-19-blog-1.sql

Created September 29, 2013 20:46
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save troyscott/6756385 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save troyscott/6756385 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
2010-07-19-blog-1.sql
update dbo.WeeklySalesForecast
set WeekNumber = case
when CONVERT( INT,SUBSTRING(WeekNumber,5,3)) < 10
then 'Week 0' + SUBSTRING(WeekNumber,6,1)
else WeekNumber end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment