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:
00597465
Vues:
26
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 >
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform