Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Stored Procedure Trouble
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00596982
Message ID:
00597490
Views:
28
Hi Matt,
I think that you have ID missmatch between those two tables. The following select will return all ID's from OGC table not found in OutbackLogin table.
SELECT OGC.OGCID
from OGC LEFT OUTER join OutbackLogin ON OGC.OGCID = OutbackLogin.OLUserID
WHERE OutbackLogin.OLUserID IS NULL 
GROUP BY 1
>The results for that query are:
>
>ADMIN 6
>CSR 21
>OGC 276
>TM 48
>
>>Can you run one more query and post result?
>>
SELECT OutbackLogin.OLUserType, COUNT(*)
>>FROM OutbackLogin
>>GROUP BY 1
>>
>>>When I run the query below it just returns this:
>>>
>>>OGC 10072 10590
>>>
>>>>Can you just cut and paste those two lines?
>>>>
>>>>>I would, but there is a total of 278 records that it returns from the table whenever I run the query.
>>>>>
>>>>>>Can you post results for CSR and ADMIN usertypes? Just copy it from QA result window.
>>>>>>
>>>>>>>I ran your code in a query and the results return where that the minimum number was 10072 and the maximum number was 10590
>>>>>>>
>>>>>>>>In this case something wrong in your logic. Run following select to see Id ranges for each usertype.
SELECT OutbackLogin.OLUserType, MIN(OGC.OGCID), MAX(OGC.OGCID)
>>>>>>>>from OGC inner join OutbackLogin ON OGC.OGCID = OutbackLogin.OLUserID
>>>>>>>>GROUP BY 1
>>>>>>>>
>>>>>>< snip >
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform