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)

It would help if you could also post the DDL for the table(s), sample data, expected results based on the sample data.

If you need help with this, please read and...

I use CHAR(13) + CHAR(10) when I need to insert a sequence in a string.

To be honest, I don't know how to your questions as there is very little real information in any of your posts. All I know is some scheduled job...

Sorry, tired eyes. I read your post wrong. First, it would help to see the actual error message. Second, it would also help if you would post...

What does the stored procedure return?