What have you tried so far? You can start by looking at dbo.sysjobhistory table in msdb database

You do realize that this forum is for SQL Server?

How do you expect to join these tables? for your expected results, why don't the first 4 rows of table one match the first 2 of table 2?

How do you calculate dq_cycle_cnt in your spreadsheet? How do you know when a new district starts? How did you calculate the dq_rec_start_cycle_ind in the spreadsheet?

can you provide some ddl and what your expected results are?

You can use a cte for this.  I'm assuming that the EXTL_ACCT_NMBR is the key.

declare @t table (

PlanAccountKey int,

CPNY_CODE nvarchar(3),

EXTL_ACCT_NMBR nvarchar(30),

PLAN_NMBR int,

CATE_NMBR tinyint,

STRT_DATE datetime,

END_DATE Datetime)

insert into @t

select 519426,'001','001065007745823',101491, 2, '2003-09-04','2004-09-03'...

To avoid confusion for testing, use a day greater than 12.

Declare @DateString datetime

SET @dateString = CONVERT (datetime, '2012-15-04', 103)

SELECT CONVERT(nvarchar(20),@dateString,103) DateConverted

After I de-simplified(?) it to apply to my needs, the query worked flawlessly. Chris, thanks for your help.

I think if you READ some of the comments and provide the correct data, we might be able to help. Just asking for help won't get you any unless...

I'm trying to understand what you are looking for, but you seem to be all over the place. Your original post said that you were looking for rows where...

I agree with you

I modified your cte a little and I think these might be the results you're looking for

;WITH cte AS (

SELECT *,

ROW_NUMBER() OVER(PARTITION BY EventNumber, OBJECTID, ObjectSerial ORDER BY [TIMESTAMP])...

It depends on what you mean by First Day and Last Day of week. This code assumes the first day of the week is Sunday and the last is...

Thanks, I'll give it a try and let you know how it works out

unfortunately it's a push subscription