Error converting data type varchar to numeric.

• yogeshkadvekar

  SSC Rookie

  Points: 33

  More actions

  May 15, 2008 at 11:36 pm

  #123908

  hi

  i m writting following code

  declare @i as numeric(18,0)

  declare @sql as varchar(8000)

  set @i =4

  set @sql ='select top '+@i+' * from dbo.tbl_ls_feed_data'

  exec(@sql)

  i mgetting error to Error converting data type varchar to numeric.

  how to cast @i in this case

• Zahran

  SSCommitted

  Points: 1724

  More actions

  May 16, 2008 at 2:23 am

  #816304

  declare @i as numeric(18,0)

  declare @sql as varchar(8000)

  set @i =4

  set @sql ='select top ' + convert(varchar,@i) + ' * from dbo.tbl_ls_feed_data'

  exec(@sql)

  - Zahran -

• yogeshkadvekar

  SSC Rookie

  Points: 33

  More actions

  May 16, 2008 at 4:34 am

  #816338

  thx

• yogeshkadvekar

  SSC Rookie

  Points: 33

  More actions

  May 16, 2008 at 4:36 am

  #816341

  thx

• jaypee_s

  Right there with Babe

  Points: 793

  More actions

  May 16, 2008 at 5:21 am

  #816361

  Hi

  declare @i as varchar(25)

  declare @sql as varchar(8000)

  set @i =4

  set @sql ='select top '+@i+' * from dbo.type_master'

  exec(@sql)