I have written this query I am trying to append the @Cond variable to the query
declare @Cond varchar(50)=''
set @Cond=' Addr_Conf=0 and Kit=0 and Item_PRB=0 and '
-- Insert statements for procedure here
Select distinct Cust_Order.ID,eBay_Items.SKU from Cust_Order,Cust_Orders_Det , eBay_Items where
Cust_Orders_Det.Prd_ID=eBay_Items.ID and Cust_Orders_Det.Order_ID=Cust_Order.ID and @Cond +
Cust_Acc_No
in
(Select distinct top(50) Cust_Order.Cust_Acc_No from eBay_Items, Cust_Orders_Det,Cust_Order where Cust_Orders_Det.Prd_ID=eBay_Items.ID and Cust_Orders_Det.Order_ID=Cust_Order.ID order by Cust_Order.Cust_Acc_No) order by sku desc
But it gives error
Conversion failed when converting the varchar value ' Addr_Conf=0 and Kit=0 and Item_PRB=0 and ' to data type int.
Select distinct Cust_Order.ID,eBay_Items.SKU from Cust_Order,Cust_Orders_Det , eBay_Items where
Cust_Orders_Det.Prd_ID=eBay_Items.ID and Cust_Orders_Det.Order_ID=Cust_Order.ID and '+@Cond+'
Cust_Acc_No
amjad905
Member
569 Points
519 Posts
SQL Query
May 05, 2012 10:32 AM|LINK
Hi,
I have written this query I am trying to append the @Cond variable to the query
declare @Cond varchar(50)='' set @Cond=' Addr_Conf=0 and Kit=0 and Item_PRB=0 and ' -- Insert statements for procedure here Select distinct Cust_Order.ID,eBay_Items.SKU from Cust_Order,Cust_Orders_Det , eBay_Items where Cust_Orders_Det.Prd_ID=eBay_Items.ID and Cust_Orders_Det.Order_ID=Cust_Order.ID and @Cond + Cust_Acc_No in (Select distinct top(50) Cust_Order.Cust_Acc_No from eBay_Items, Cust_Orders_Det,Cust_Order where Cust_Orders_Det.Prd_ID=eBay_Items.ID and Cust_Orders_Det.Order_ID=Cust_Order.ID order by Cust_Order.Cust_Acc_No) order by sku descBut it gives error
Conversion failed when converting the varchar value ' Addr_Conf=0 and Kit=0 and Item_PRB=0 and ' to data type int.
ZeeshanAnsar...
Participant
878 Points
264 Posts
Re: SQL Query
May 05, 2012 10:37 AM|LINK
this way you cannot execute query
instead go for dynamic query like
Please 'Mark as Answer' if this post helps you.
Frank Jiang ...
All-Star
16006 Points
1728 Posts
Microsoft
Re: SQL Query
May 08, 2012 08:28 AM|LINK
Try this:
Read sp_executesql
Feedback to us
Develop and promote your apps in Windows Store
mnmhemaj
Member
197 Points
165 Posts
Re: SQL Query
May 08, 2012 08:45 AM|LINK
Refer to this link:
http://blog.sqlauthority.com/2007/07/02/sql-server-2005-comparison-sp_executesql-vs-executeexec/
sriramabi
Contributor
4351 Points
1277 Posts
Re: SQL Query
May 08, 2012 09:45 AM|LINK
pls check
http://stackoverflow.com/questions/2654393/conversion-failed-when-converting-the-varchar-value-to-data-type-int
http://stackoverflow.com/questions/10215171/conversion-failed-when-converting-the-varchar-value-n-to-data-type-int
http://stackoverflow.com/questions/10215171/conversion-failed-when-converting-the-varchar-value-n-to-data-type-int
http://social.msdn.microsoft.com/Forums/eu/transactsql/thread/e0ddaa76-8184-4e26-aa96-9266f68319d5
http://forums.asp.net/t/1791785.aspx/1
http://forums.asp.net/t/1797457.aspx/1