Error converting data type varchar to numeric.

Question

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Zahran SSCommitted Points: 1724 More actions · Answer 1

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 Valued Member Points: 53 More actions · Answer 2

Valued Member

Points: 53

May 16, 2008 at 4:34 am

thx

yogeshkadvekar Valued Member Points: 53 More actions · Answer 3

Valued Member

Points: 53

May 16, 2008 at 4:36 am

thx

jaypee_s Right there with Babe Points: 793 More actions · Answer 4

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)