General information
Forum:
Microsoft SQL Server
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only