Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
Conversion failed when converting the varchar value to int
Manohar Gova
Jul 15 2015 4:15 AM
745
Reply
Hi ,
while executing the below query getting error
declare @thirdpartyvendorid varchar(1000)
declare @thirdpartyvendoridNew varchar(1000)
select
@thirdpartyvendorid = a.thirdpartyvendorid
from dbo.stageloaninfo a (nolock)
where slid='160897'
select @thirdpartyvendoridNew = COALESCE(@thirdpartyvendoridNew + ', ','') +CONVERT(VARCHAR, V.VendorID) from Vendors V
where V.VendorID in (CAST(@thirdpartyvendorid as varchar )) and VendorType = 4
select @thirdpartyvendoridNew
Anybody pls help
Conversion failed when converting the varchar value '1130,1117' to data type int.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
use of SUBSTRING function in WHERE clause using SQL SERVER 8
how to count row size in mysql