Skip to Content
0
Former Member
May 18, 2010 at 06:50 PM

Query

24 Views

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