You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
34 lines
732 B
34 lines
732 B
USE [FastMoneyPro_Remit]
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[proc_dropDownListsAC] Script Date: 7/4/2019 11:35:48 AM ******/
|
|
DROP PROCEDURE [dbo].[proc_dropDownListsAC]
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[proc_dropDownListsAC] Script Date: 7/4/2019 11:35:48 AM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
CREATE PROC [dbo].[proc_dropDownListsAC]
|
|
@flag VARCHAR(200)
|
|
,@param VARCHAR(200) = NULL
|
|
,@user VARCHAR(30) = NULL
|
|
|
|
AS
|
|
SET NOCOUNT ON;
|
|
|
|
IF @flag = 'sAgent'
|
|
BEGIN
|
|
SELECT
|
|
agent_name,
|
|
map_code
|
|
FROM FastMoneyPro_account.DBO.agentTable WITH(NOLOCK)
|
|
WHERE AGENT_TYPE = 'Sending' and isnull(agent_status,'y') = 'y'
|
|
ORDER BY agent_name ASC
|
|
RETURN;
|
|
END
|
|
|
|
|
|
|
|
|
|
|
|
GO
|