Viewing 2 posts - 1 through 2 (of 2 total)
Removing the single quotes dod nit make a diference.
March 17, 2008 at 11:20 am
#790458
SELECT '999' + RIGHT([Temporay ID], 5) AS ID, NULL
AS [Actual End Date], 'Terminated' AS status, [Actual End Date]
+ 1 AS Start_date, case when [Actual...
March 14, 2008 at 1:04 pm
#789849