Hi guys,

today i added 8 extra columns (in total there 14 columns now which are calculated) with wayne's routine. The test i did today was on a table with 21.000.000...

Hi Wayne and other techies,

Today i tested Wayne's routine on a table with 20.000.000 records. In total 6 columns are calculated and updated by Wayne's routine and it took 6...

Hi guys,

I'am testing the routine right now on a table with 26.000.000 records, tomorrow i will give the performance results.

Thanks very much for all your knowledge input

Have a nice evening...

Hi Wayne,

WOW !!!!!!!!!, I have tested it and add an extra column and it works greatly , I'am very impressed with your skills !!!!

Thank you soooo much.

How do you think...

Hi John,

Here's the new testtable with data (works also on SQL Server 2005)

as you can see there are 3 different category,class location combinations in this testfile

category=111

class=5010

location=210

category=111

class=5010

location=230

category=111

class=5010

location=240

for every category,class,location combination RowNum...

Hi John,

Ok i understand. I can send another smaller testfile with some data. I will create something for you.

Do you think you have a working solution for my problem?

Regards,

Dick Herberts

i...

Hi,

Well, that's the way SQL Server 2008 R2 generates the script with data. If I run this script every thing looks fine. Teh column Datum (date in dutch) is a...

Hi ,

1. I'am using SQL Server 2008 R2

2. This is for real and not home work or whatever

3. Primary key is Category,Class,Location,RowNum

4. No clustered index yet

Regards,

Dick Herberts

This is the...

Hi ,

Wow , sounds too good to be true. Do you have an example , Please help

Regards,

Dirk