Home Forums SQL Server 2005 Business Intelligence Expressions for Variables RE: Expressions for Variables
stevefromOZ
SSC-Forever
Points: 43646
More actions
October 19, 2009 at 2:09 pm
#1067828
Sorry, looks like it's supported in 2008, perhaps not 2005. (here)
You can use the shortcut version of If/Iff , like .....
DatePart("mm", GETDATE()) == 1 ? "012" : "0" + (DT_WSTR,30)DatePart("mm", GETDATE())
Steve.