Did you convert it to an SSIS package, or leave it as DTS?

Looks to me like you should be able to change that in the report designer. Is there some reason you can't?

It's possible, but there are caveats on it. Take a look for Jeff Moden's Running Totals article on this site.

Grant Fritchey (2/13/2009)

---

I don't have a Bachelors. So there!

And I don't have a single certification (well, a 14 or 15 year old one from Sybase, but I'm pretty sure that...

Most likely means that the backup file you selected isn't the one you actually wanted. I'd definitely double-check that.

I prefer a more adventurous company, but there has to be a balance.

One company I worked for took some risks on moving to a whole new industry. I was...

Actually, we just had a touch of that on...

Whoa! I'm assuming you've tested it thoroughly first, right?

I think this will get you what you need. I can't really test it fully, not having access to your system, but it should be okay.

if object_id(N'tempdb..#Numbers') is not...

Here's a version that works in 2000:

if object_id(N'tempdb..#Numbers') is not null

drop table #Numbers

create table #Numbers (

Number int identity primary key,

PlaceHolder bit);

insert into #Numbers (PlaceHolder)

select top 1000 null

from dbo.syscolumns;

declare @String char(168);

select...

You'll need to look for what registry keys, etc., are telling Windows that SQL Server was ever installed. As mentioned, I'm not sure which ones those are, it's just...

bear in a box (2/13/2009)

---

if anyone of you grew beside the sea, if anyone of you had a river beside your family's farm?

my location is close to the equator, i...

Here are some facts:

**CO2 IS A GREENHOUSE GAS**. It re-radiates infrared/thermal radiation. This has been scientifically replicated and has been known for at least the last 100 years. The Swedish...

Yes, that should get the date of the last day of the current month. Test it with a few dates like Jan 31, in place of getdate, and see...

Carlo Clausius (2/12/2009)

---

The debate about global warming is mute. The fact is, intense human activity has a detrimental impact on the earth's environment. I see it in the...