Jack Corbett (12/2/2008)

---

You can use a script to check the properties of the file to see if it is in use and then skip it. Whenever anyone is dealing with...

Not only sample data, but also the DDL for the tables. Please read the article referenced in my signature block about asking for help to see how best to...

pri.amin (12/2/2008)

---

Can anyone see an problems with the beloew code?

The tables it is using to populate tbldeals are temp tables.

The insert seems to insert the data correct but duplicates it...

Another option is as follows:

declare @TestTbl table (

Date1 datetime,

Date2 datetime,

Date3 datetime

);

insert into @TestTbl

select '2008-11-11 12:00:00.000', '2008-11-12 08:30:34.333', '2008-11-13...

When did you upgrade the database to SQL Server 2005 and compatibility mode 90?

I just did some testing on a SQL Server 2000 instance, a database in compatibility mode 80...

Probably need it to look like this: WHILE @date <= @Enddate

Your problem is right here: WHILE @date @Enddate

I'd verify that all the databases are set to compatibility level 90.

Haven't looked at your code, but a good article on computing running balances is referenced below in my signature block. It is worth a read if you haven't yet.

I was being cautious, datediff(mm, '2008-11-30', '2008-12-01') returns 1. Since it looks like you are going back over 10 months, not too much to worry about (I hope).

I guess we really could use the DDL for your tables, some sample data, and the expected results based on the sample data. To see how you should post...

I think I like my solution better. You seem to be making it harder than it really is. You can extract the date from the end of the...

I have to ask, what edition of SQL Server 2005 are you using?

I can think of one reason. We restore the one of our databases as a previous year database that is read only. We shrink the database prior to making...

Made a few slight changes. If you have a test server, you might give the following a spin:

-- Declare variables to store database name returned by FETCH and the...