SQL Query

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 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.

Re: SQL Query

this way you cannot execute query

instead go for dynamic query like

declare @qauery nvarchar(1000)
set @query='Select * From table1'
exec sp_executesql @query

Re: SQL Query

Try this:

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

Read sp_executesql

Re: SQL Query

Refer to this link:

http://blog.sqlauthority.com/2007/07/02/sql-server-2005-comparison-sp_executesql-vs-executeexec/

Re: SQL Query

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://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