Skip to Content
0
Former Member
May 27, 2013 at 07:41 PM

Need help with a derived table expression code

23 Views

Hello all ,

I'm new to this. I'm trying to get a derived table from SQL using the following where clause in my select and "It cannot process" I get to explanation on why this doesnt work, The clause works great in SQL query but when I try to use it in expression editor it doesnt. Please help !!! 😢

where

Convert(INTEGER,substring(@Variable('BOUSER'),1,charindex('-',@Variable('BOUSER'))-1))=0 or Convert(integer,substring(@Variable('BOUSER'),1,charindex('-',@Variable('BOUSER'))-1))= dbo.Facility.FacilityNumber

Thank you all in advance!