Conversion failed when converting the nvarchar val

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources