| Author |
 Topic  |
|
|
micnie_2020
Posting Yak Master
Malaysia
232 Posts |
 Posted - 11/29/2012 : 06:13:33
|
declare @i int
declare @val nvarchar(30)
declare @sSQL nvarchar(4000)
set @i=2
set @val='Test'
set @sSQL=N'insert into pivottbl'+@val+'(Dates)select replace(convert(varchar, cast(DateAdd(m,'+@i+'-1,''15/09/2012'') as date), 113),'' '',''/'') '
exec sp_executesql @sSQL
|
|
|
madhivanan
Premature Yak Congratulator
India
22864 Posts |
Posted - 11/29/2012 : 06:19:21
|
declare @i int
declare @val nvarchar(30)
declare @sSQL nvarchar(4000)
set @i=2
set @val='Test'
set @sSQL=N'insert into pivottbl'+@val+'(Dates)select replace(convert(varchar, cast(DateAdd(m,'+cast(@i as varchar(10))+'-1,''15/09/2012'') as date), 113),'' '',''/'') '
exec sp_executesql @sSQL
Madhivanan
Failing to plan is Planning to fail |
 |
|
| |
Topic |
|
|
|
Conversion failed when converting the nvarchar val