Well, you did provide us with data, but unfortunately it isn't in a readily consummable format and I really don't have time to put it into a usable format at...

Not asking for actual data. You should be able to create a data set that is representative of your actual data that also reflects the problem you are trying...

This part is confusing:

The problem I have which I may need help with is that, the system I have is based on the year ending on the first Saturday of...

Now all that is missing is the sample data and expected results.

Paul White (9/13/2009)

---

You're right Lynn - and I did mean to post an introduction...but life got in the way I'm afraid. Sorry.

Many of you might recognise Matt's name from...

Paul White (9/13/2009)

---

Hey Bob & Lynn,

Please direct pork chops to me rather than Matt. We had a very interesting discussion on the site earlier, and it came up that...

setiv (9/13/2009)

---

Hi

-- ...

Totally different subject.

Then you have this. Not only that, I seem to have a groupie. I found this post as the respondant PM'ed me the thread!

Matt,

The best way to have requested such help would probably have been to post your requests in the Anything the is NOT about SQL forum in its own thread. ...

If SQL Server is doing a table scan it means it doesn't think any of the indexes are useful. Please read and follow the instructions in the second article...

I'd start with BOL (Books Online).

First, you probably shouldn't have created the trace table in the master database, but since you did, oh well.

You should be able to consume the data from the table directly...

Have you updated the statistics on the SQL Server 2005 database?

Please read the article I suggested. Unless I want to take the time to write CREATE TABLE and INSERT statements, there really isn't much in your latest post that...

Does this help you get where you are trying to go?

declare @PayDate datetime;

set @PayDate = '2006-12-01';

select cast(year(dateadd(mm,3,@PayDate)) as char(4)) + '-' + right(cast(year(dateadd(mm,3,@PayDate)) - 1 as char(4)), 2)