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.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Conversion failed when converting the nvarchar val

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 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
Go to Top of Page
   

- Advertisement -