You could find whoever wrote your proprietary system that you're no allowed to change and tell them to fix it? My suggestion to them would be to create a...

You've got a record in there that doesn't contain a ',' after the last name.

that would be the if the data's not the same for each record it becomes increasingly...

Besides the fact that there's no Select clause... I'd imagine your error lies somewhere here...

(case when current_date('&Date', 'MM/DD/YYYY') > trunc(sysdate)-1

...

actually I had a typo in mine... What I meant to post was...

CREATE TABLE #temp (

FullName VARCHAR(50))

INSERT INTO [#temp]

SELECT 'Austin, Martin B' UNION ALL

SELECT 'Brown, Steven A' UNION ALL

SELECT...

so something like the following may work for you I suppose?

CREATE TABLE #temp (

FullName VARCHAR(50))

INSERT INTO [#temp]

SELECT 'Austin, Martin B' UNION ALL

SELECT 'Brown, Steven A' UNION ALL

SELECT 'Carter, Marvin...

Looks like I was a bit late to the party and you've already posted some sample data. one question about it though. Do you allow people to have...

Firstly, having a name in your database called Fullname containing First MI and Last probably isn't the best idea from ta design standpoint as you probably also have columns with...

You need to copy the datasource to each one of your project's datasource folder, but in the project properties make sure they all point back to http://servername/resportserver/datasources or something like...

Exactly, If you setup a shared datasource in your Report Project/Solution you can point all of your reports to that datasource. Then just publish the datasource with the reports.

Additionally...

sorry about the delay I was out of the office for a few days.

Yes. I deploy reports from my workstation to my report server in another building....

Not sure since I don't have a sql 2000 version of RS, but it seems to me you should be able to query your reportserver database (the one that contains...

no script is needed, inside of VS just select the reports you want to deploy, right click and deploy them.

If you want to do it in a script you can...

No one ever said the sample data had to be real your actual data.

Kudos on the improvement so far, but I'd have to imagine that you should be able to...

Any chance you could pass along a bit of sample data and ddl as per http://www.sqlservercentral.com/articles/Best+Practices/61537/.

With just a quick look is this something that might go faster if you break...

No chance that your tempdb had gotten out of hand and sucked up all of your disk space is there? the Service restart would have freed up that space...