quote:

---

Originally posted by revdnrdy

Well just taking a stab at it..

Shouldn't the syntax be

INSERT INTO @ValidAccounts

rather than

INSERT @ValidAccounts ?

r&r

---

quote:

---

Originally posted by revdnrdy

ok I wasn't sure..

What does this function do?
fxAnalysis_v0400_000_QueryAccounts ('Q', @ParmUserKey, @ParmFiscalYearEnd, @ParmFiscalYearEnd)

Why do you feed it @ParmFiscalYearEnd twice? I ask naively of course.

r&r

---

DECLARE	@ParmOpMode char (1), 
	@ParmUserKey int,
	@ParmFiscalYearEnd smallint,
	@ParmSocial char (9),
	@ParmDateSelectType tinyint,
	@ParmDate1 datetime,
	@ParmDate2 datetime,
	@SocialMask Char (9)

DECLARE @AccountList TABLE
	(
		RowType tinyint,
		UserKey int,
		FiscalYearEnd smallint,
		Account char (19),
		DisplayAccount char (24),
		DistrictName char (30),
		FullName char (50),
		Social char (9),
		PayDate datetime,
		Amount money,
		GrandTotalAmount money
	)

SELECT	@ParmOpMode = 'Q',
	@ParmUserKey = 10020,
	@ParmFiscalYearEnd = 2009,
	@ParmSocial = '*********',
	@ParmDateSelectType = 1

SET	@SocialMask = REPLACE (@ParmSocial, '*', '_')

DECLARE @DistrictName char (30),
	@EarlyDate DateTime,
	@LateDate DateTime,
	@QueryBeginDate DateTime,
	@QueryEndDate DateTime,
	@TempTotalAmount money

SELECT	@EarlyDate = '01-01-1980 12:00 AM',
	@LateDate = '12-31-2099 11:59:59 PM'

SELECT	@QueryBeginDate = @EarlyDate,
	@QueryEndDate= @LateDate

IF @ParmDateSelectType = 1
	SELECT	@QueryBeginDate = @EarlyDate,
		@QueryEndDate = @LateDate

IF @ParmDateSelectType = 2
	SELECT	@QueryBeginDate = @ParmDate1,
		@QueryEndDate = @LateDate

IF @ParmDateSelectType = 3
	SELECT	@QueryBeginDate = @EarlyDate,
		@QueryEndDate = @ParmDate1

IF @ParmDateSelectType = 4
	SELECT	@QueryBeginDate = @ParmDate1,
		@QueryEndDate = @ParmDate2

IF @ParmDateSelectType = 5
	SELECT	@QueryBeginDate = @ParmDate1,
		@QueryEndDate = @ParmDate1

SELECT	@DistrictName = DistrictName
FROM	ResaDistrict

DECLARE @ValidAccounts TABLE
	(
		FiscalYearEnd smallint,
		Account char (19) PRIMARY KEY,
		DisplayAccount char (24)
	)

INSERT	@ValidAccounts 
	(
		FiscalYearEnd,
		Account,
		DisplayAccount
	)
SELECT	FiscalYearEnd,
	Account,
	DisplayAccount
FROM	fxAnalysis_v0400_000_QueryAccounts('Q', @ParmUserKey, @ParmFiscalYearEnd, @ParmFiscalYearEnd) AS fxqa

IF @SocialMask = REPLICATE ('_', 9)
	INSERT		@AccountList 
			(
				RowType,
				UserKey,
				FiscalYearEnd,
				Account,
				DisplayAccount,
				DistrictName,
				FullName,
				Social,
				PayDate,
				Amount,
				GrandTotalAmount
			) 
	SELECT		1 AS RowType,
			@ParmUserKey AS UserKey,
			'2009',
			'1234567890123456789',
			'12-345-6789-012-345-6789',
			@DistrictName AS DistrictName,
			pe.FullName,
			pe.Social,
			gl.dDate AS PayDate,
			gl.Amount AS Amount,
			0 AS GrandTotalAmount
	FROM		PayEmployee as pe
	INNER JOIN	PayGlDist AS gl ON gl.Social = pe.Social
				AND @QueryBeginDate <= gl.dDate
				AND gl.dDate <= @QueryEndDate