I guess this is an 'inplace' upgrade.

The way that I am copying the tables are:

1- Transfer al; table from stage to reporting using a temp table

2- Drop all reporting tables

3- Rename all temp tables to reporting...

Thx all.

I did write function but the one of Drew is way more elegant.

Rem

Thanks Michael, but I need to find the number of trimesters between 2 dates, even if they are no tin the same year.

Ex:

2010-05-10 and 2010-07-01 will be 0

2010-04-30 and 2010-05-01...

Here my trimesters:

A trimester is period of three months

Jan to Apr = Trimester #1

May to Aug= Trimester #2

Sep to Dec = Trimester #3

I also need to get the...

I am running the Standard Edition with SP2. So I need to add the trace flag, right?

Should I stay with SYSTEM as account running the service?

Rem

As of now, the user running the SQL process is SYSTEM. Should I apply this policy to this user? Will this be OK?

This looks very interesting. I will have to dig a little to fully understand the query, It's the first time I am seeing something like this. If...

Doh, How can I missed this !!!!!:Whistling:

and where should I go to get Cumulative update package 8 for SQL Server 2005 Service Pack 3?

Hi Vikas,

Did you faced the problem again?

Rem

Hello,

By SP, I meant Service Pack.

Hi Vikas,

I will try to do this gymnastic this week with the packages I have problems.

Did you bring all the original names of your packages?

I will keep you...

Hi All,

I still have the issue. If I rename the packages, this mean I will need to change a lot of parent-child combinations packages. These were running for months...

HI,

I am able to rename the .dtsx without any problem.

One thing is when I run the parent package in BIDS, the child package failed. At this point...