>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
May not be able to nest sub-queries.
You using MS SQL Server?
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
