SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

-- Drop store procedure if it exists
IF EXISTS (SELECT name 
	   FROM   sysobjects 
	   WHERE  name = N'dbo.procAcctStatusSort' 
	   AND 	  type = 'P')
    DROP PROCEDURE dbo.procAcctStatusSort
GO



CREATE PROCEDURE dbo.procAcctStatusSort 
	@SortOrder int -- 1 = Acct No, 2 = Alpha, 3 = Desc Amt.
/******************************************************************************
**		Name: procAcctStatusSort
**		Auth: John Swaringen
**		Date: 6/20/2001
**		Desc: This procedure sorts the temporary tables according to the 
**			  parameter that was passed in.
*******************************************************************************
**		Change History
**		Date:		Author:				Description:
**		--------	--------			---------------------------------------
**    
**
** =============================================
** example to execute the store procedure
** =============================================
** EXECUTE procAcctStatusSort 1
** GO
*******************************************************************************/
AS

SET NOCOUNT ON

if exists (select * from dbo.sysobjects where id = object_id(N'[#tempAcctStatus]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [#tempAcctStatus]

CREATE TABLE #tempAcctStatus 
	(
	[lTmpAccountNumber_id] [int] NULL ,
	[szTmpTaxAccountNumber_id] [varchar] (30) NULL ,
	[lTaxUnit_id] [int] NULL ,
	[lTmpStatusCode_id] [int] NULL ,
	[szTmpSAlphaCode_nm] [char] (4) NULL ,
	[lTmpRollCode_id] [int] NULL ,
	[szTmpRAlphaCode_nm] [char] (4) NULL ,
	[szTmpName1] [varchar] (50) NULL ,
	[mnyTmpLevyBal] [money] NULL ,
	[szDeleteFlag] [char] (1) NULL 
	)

-- Create and Insert rows into temp table
INSERT INTO #tempAcctStatus
	SELECT lTmpAccountNumber_id, 
		szTmpTaxAccountNumber_id, 
	    lTaxUnit_id, 
		lTmpStatusCode_id, 
		szTmpSAlphaCode_nm, 
	    lTmpRollCode_id, 
		szTmpRAlphaCode_nm, 
		szTmpName1, 
	    mnyTmpLevyBal, 
		szDeleteFlag
	FROM tmpAcctStatus

-- Delete from original table
DELETE FROM tmpAcctStatus

IF @SortOrder = 1
BEGIN
	INSERT INTO tmpAcctStatus
		SELECT lTmpAccountNumber_id, 
		szTmpTaxAccountNumber_id, 
	    lTaxUnit_id, 
		lTmpStatusCode_id, 
		szTmpSAlphaCode_nm, 
	    lTmpRollCode_id, 
		szTmpRAlphaCode_nm, 
		szTmpName1, 
	    mnyTmpLevyBal, 
		szDeleteFlag
		FROM #tempAcctStatus
		ORDER BY lTmpAccountNumber_id
END
ELSE
	IF @SortOrder = 2 
BEGIN
	INSERT INTO tmpAcctStatus
		SELECT lTmpAccountNumber_id, 
		szTmpTaxAccountNumber_id, 
	    lTaxUnit_id, 
		lTmpStatusCode_id, 
		szTmpSAlphaCode_nm, 
	    lTmpRollCode_id, 
		szTmpRAlphaCode_nm, 
		szTmpName1, 
	    mnyTmpLevyBal, 
		szDeleteFlag
		FROM #tempAcctStatus
		ORDER BY szTmpName1
END
ELSE IF @SortOrder = 3 
BEGIN
	INSERT INTO tmpAcctStatus
		SELECT lTmpAccountNumber_id, 
		szTmpTaxAccountNumber_id, 
	    lTaxUnit_id, 
		lTmpStatusCode_id, 
		szTmpSAlphaCode_nm, 
	    lTmpRollCode_id, 
		szTmpRA