my query
DECLARE @Curr_Date DATETIME;
--Set @Curr_Date = CURRENT_TIMESTAMP;
set @Curr_Date = '2015-06-03 00:00:00.000'
SELECT RTrim(c.REFERENCE_NO) + '|', 'HBBCKGRND' + '|' AS Literal , 'Refund Check Sent', RTrim([DESCRIPTION]) + ', ' + LTrim([TRANS_NBR])...