The following code is in a stored procedure. Can
somebody please just confirm if this is a valid SQL
Statement. I appreciate this is not a SQL Forum. I'm a
ColdFusion developer and am trying to query the db.

SET @SQLStatement = @SQLStatement + 'SELECT * From
Employee where Employee.asstetID IN (select distinct
Employee.callNo from Employee where Employee.asst_id
IN (select Assets.asst_id from Assets where bar_code =
' + char(39) + @asset + char(39) + '))'

Thanks in advance



__________________________________
Do you Yahoo!?
Yahoo! Domains � Claim yours for only $14.70/year
http://smallbusiness.promotions.yahoo.com/offer
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to