Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Stored Procedure Trouble
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
00596982
Message ID:
00597444
Vues:
22
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 >
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform