1select rtrim(substring('Rama Cahn 345345345345',1,16))
2
3select convert(varchar(8),'01/01/08',3)as Effdate
4
5select replicate('Y',9)
6
7select stuff('0101',3,0,':')
8
9select HCOVRDEP = case when HCOVRDEP=0 then 'N' else 'Y' end from table
10
11select ltrim(rtrim(' Ram '))
12
13Insert SP end
14 If @@ERROR = 0
15 Select '1'
16 else
17 Select @@ERROR
18
19CAST(ISNULL(A.CreateYN,0) AS BIT) AS CreateYN
20
21Cast((CASE WHEN REC.FINMultipleReceiptID IS NULL THEN 0 ELSE 1 END )AS BIT)AS IsBulk,
22
23CASE WHEN HB_ClaimAction.ActionStatusLK != 2838
24THEN CONVERT(bit, 1) ELSE CONVERT(bit,0) END