asked on
USE [JTSConversion]
GO
/****** Object: StoredProcedure [dbo].[spzBogus] Script Date: 11/23/2017 8:40:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- Batch submitted through debugger: SQLQuery2.sql|7|0|C:\Users\MIke72\AppData\Local\Temp\~vs636E.sql
ALTER PROCEDURE [dbo].[spzBogus]
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
declare @passedMuniCode int,
@passedExcludeHoldClass01 int,
@passedExcludeHoldClass02 int,
@passedExcludeHoldClass03 int,
@passedExcludeHoldClass04 int
Set @passedMuniCode = 877
Set @passedExcludeHoldClass01 = 1
set @passedExcludeHoldClass02 = null
set @passedExcludeHoldClass03 = null
set @passedExcludeHoldClass04 = null
--
Create Table #tempExcludedTAs(TaxAuthorityID int)
Execute spGetExcudedTAsBasedOnHoldRestriction @passedMuniCode,
@passedExcludeHoldClass01,
@passedExcludeHoldClass02,
@passedExcludeHoldClass03,
@passedExcludeHoldClass04
END
USE [JTSConversion]
GO
/****** Object: StoredProcedure [dbo].[spGetExcudedTAsBasedOnHoldRestriction] Script Date: 11/23/2017 8:41:54 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spGetExcudedTAsBasedOnHoldRestriction]
--
-- This will only be done on a set of records so no need to pass propertyID
-- Most holds will apply to the entire property rather than a specific TA so no TAID or Tax TypeID is passed
--
@passedMuniCOde int = null,
@passedExcludeHoldClass01 int = null,
@passedExcludeHoldClass02 int = null,
@passedExcludeHoldClass03 int = null,
@passedExcludeHoldClass04 int = null
AS
Begin
SET NOCOUNT ON;
insert Into #tempExcludedTAs
SELECT TaxAuthorityID
From vtblTaxAuthortity_PropID_TAID_Muni_HoldTypeID_HoldClassID
-- WHERE
-- ((@passedMuniCOde is null) or (MuniCode = @passedMuniCOde)) -- AND
-- ((@passedExcludeHoldClass01 is null) or (HoldClassID IN (@passedExcludeHoldClass01,
-- @passedExcludeHoldClass02,
-- @passedExcludeHoldClass03,
-- @passedExcludeHoldClass04)));
--
end