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:
00597444
Views:
29
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 >
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform