I am having trouble getting one of my queries to work. I have several queries that pull data from a User table very successfully.
Here are the queries that are working
SELECT T0.U_BPName FROM [dbo].[@SLS_PERSON_REGION] T0
WHERE T0.U_SlsPerNum = $[OCpr.U_SalesRepno]
and
SELECT T0.[U_CustBPCode] FROM [dbo].[@SLS_PERSON_REGION] T0 WHERE $[OCpr.U_SalesRepno] = T0.U_SlsPerNum
There is one field that I can not get to work.
SELECT T0.U_Territory2 FROM [dbo].[@SLS_PERSON_REGION] T0
WHERE T0.U_SlsPerNum = $[OCpr.U_SalesRepno]
Any help would be appreciated.
Thanks