SQL Server Error: Conversion failed when converting the nvarchar value R to data type int

Omega

SOLVED CLOSED ACTIVE ANSWERED
User: Omega
Posted: on Sep 20, 2018 05:29 AM
Forum: SQL Server
Answer: 1
Views: 2167

i have sub_pk field as int in sup_purchase_master table and code as nvarchar in packing_slip_sub...

In Code Field values are like R100,R11,so on..

I am Using Following Query and i am getting this error Conversion failed when converting the nvarchar value 'R' to data type int...please help

SELECT [Sub_Pk],[Purchase_FK],[Quality],[Design],[Shade] ,[Tot_meter],[Actual_meter],[Damage],[Sample],[Stck_meter],[Rate],[Amount],Type,[Shade_No],[Chart],[Location],[Remarks] 
FROM [Sub_purchase_mastr] 
where [Purchase_FK] = '757' 
and sub_pk not in (Select code from Packing_Slip_Sub where [Del_SFlag] is null and substring(code,1,1)!='R')

Download FREE API for Word, Excel and PDF in ASP.Net

pandeyis...

0 3

Reply
ANSWER
User: pandeyism
Replied: on Sep 20, 2018 11:41 PM
Report

Hi Omega,

Please take reference to the below query change your query.

SQL

SELECT [Sub_Pk],
	   [Purchase_FK],
	   [Quality],
	   [Design],
	   [Shade] ,
	   [Tot_meter],
	   [Actual_meter],
	   [Damage],[Sample],
	   [Stck_meter],[Rate],
	   [Amount],
	  Type,
	  [Shade_No],
	  [Chart],[Location],
	  [Remarks] FROM [Sub_purchase_mastr]
WHERE [Purchase_FK] = '757' and  Convert(VARCHAR,sub_pk) not in
(Select code from Packing_Slip_Sub

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

SQL Server Error: Conversion failed when converting the nvarchar value R to data type int

Company

Explore

Follow us

Contact Us