I'm adding the SPARSE columns with this line of code:

'ALTER TABLE #tmpVintage ADD [VntRun' + CAST(triInputLotKey AS VARCHAR) + '] DECIMAL(18,5) SPARSE NULL, [VntPct' + CAST(triInputLotKey AS VARCHAR) +...

But doesn't the definition DECIMAL(18,5) SPARSE NULL make the column nullable?

Thanks for the reply, Dev. I'm not sure which rule I'm breaking. Can you identify it?

Anyone?

Perhaps I need to provide more information. The SELECT statement returns 364 rows, so the code is trying to add 728 DECIMAL(18,5) columns to the table. Does anyone know why...

I won't have enough...

Initially, my plan was to put everything I needed in the temp table as a column so I could use the standard 'quirky' update logic. My problem is that...

Thanks, Craig. When you say "dump it into #tmps" do you mean write the data that I'm trying to get out of my subqueries into temp tables and then...

Is it possible to include a subquery on the table being updated in the quirky update? I'm experimenting with the following code but the subqueries are not returning updated...

This is the first time I’ve seen anything like this.

The audit has been in place since the beginning of 2009 and has been very solid.

I’ve checked...

Celko,

Do you have Denali or plans to move to it? DB2? Oracle? A stronger SQL product? The reason I ask is that SQL with the [ROW | RANGE] subclause and...

ChrisM,

This works fantastic with the test data! Thanks for your efforts. Now I will see if I can make it work with my actual tables.

I had actually thought...

Thanks for your reply, R.P.Rozema.

Isn't the essence of your problem that you are trying to calculate off of percentages of a volume per shipment? In other words, shouldn't you...

Thanks for your kind reply, Celko. Your insight into the fact that this system was originally written in COBOL and converted to VB/SQL by the COBOL developer is amazing....

Thanks, J. That is the very article that I'm reading (for the second...

Oops. You are correct, I have a mistake in the spreadsheet calculations.

I forgot to mention in my original post that the product is liquid and stored in a...