Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
micnie_2020
Posting Yak Master
232 Posts |
Posted - 2012-11-29 : 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
22864 Posts |
Posted - 2012-11-29 : 06:19:21
|
declare @i intdeclare @val nvarchar(30)declare @sSQL nvarchar(4000)set @i=2set @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 @sSQLMadhivananFailing to plan is Planning to fail |
|
|
|
|
|