gary1 (10/9/2015)
Concat is not working in 2008 R2. Can you please advise how to write the below line without using concat.declare @EXPDate varchar(25) = Concat(Convert(varchar(20),dateadd(day,@RetentionDays,getdate()), 101),' ',Convert(varchar(20),dateadd(day,@RetentionDays,getdate()), 108));
Remove the CONCAT and then just use a "+" to "add" the strings together. If you want possible NULL values to be converted to empty strings, encapsulate that part in an ISNULL(thepart,'').
--Jeff Moden
Change is inevitable... Change for the better is not.