I'm sorry, that is just the original code I had in there, here is the code as it stands now and it still does not return anything for the usertypes ADMIN and CSR.


CREATE PROCEDURE sp_getAllOGCs
@LoginName varchar(20)
AS

set nocount on

If Len(@LoginName)=0
Select distinct * From OGC order by businessname,lastname,firstname
Else
Declare @UserType varchar(10)

SELECT @UserType= OLUserType FROM OutbackLogin WHERE (OLUserName = @LoginName)
If @UserType='TM'
/* Grab all of the Territory Managers' OGC's */
select distinct * from OGC inner join
OutbackLogin ON OGC.TERRMGRID = OutbackLogin.OLUserID
WHERE (OutbackLogin.OLUserName = @LoginName)
order by businessname,lastname,firstname
Else If @UserType='OGC'
/* Grab the single OGC information - This should work the same as the Load method of the DB object */
select distinct * from OGC inner join
OutbackLogin ON OGC.OGCID = OutbackLogin.OLUserID
WHERE (OutbackLogin.OLUserName = @LoginName)
order by businessname,lastname,firstname
Else If @UserType='CSR' OR @UserType = 'ADMIN'
/* Grab all of the OGC's*/
Select distinct * from OGC
WHERE OGC.OGCID Between 10000 and 29999
order by businessname,lastname,firstname
Else
Select distinct * From OGC order by businessname,lastname,firstname