Actually, you need to go back and review Kent's response... it's pretty much spot on.

What is the Primary Key of the table called "Test"?

It is possible in a view if you create a column called "TableName". Look at how they do it with the Information_Schema views... particularly the Information_Schema.Columns view.

Gates should give everyone who bought Vista a free copy of XP to install whilst we all wait for a decent version of Windows (7?) to come out in 2009....

Since it worked fine for both Matt and I, I've got to ask... are you actually using SQL Server or are you using some other RDBMS?

jos.haemers (4/6/2008)

---

Jeff,

I've posted a CREATE script for the facttable with a few records. I can't post any queries because there an no queries yet. In the future the customer wants...

Heh... and I thought I was old... 😉

Rather than "warming the cache"... try analyzing the code to see where indexes would help you solve the problem.

As previously stated, Cursor and loops of this nature WILL kill any hopes of performance...

Your pseudo code said...

-- IF TotalPrice > 0 ...sqlCodeHere

What do you want to do for...

Something is very wrong here... the original query posted by the OP works just fine.

You might want to post the CREATE statement for your fact table and maybe 10 or so rows of data (see the URL in my signature line for the right...

Not enough info... will you always have a max of 2 items. Also, it may make a difference if we knew why you wanted to do this.

Heh... funny thing is, I'm "old school" as well and I always say "S-Q-L" instead of "sequal".

As you said, doesn't matter how I hear it.

Wow! I totally missed the fact that the object of the update was a system table.

Updating the system tables directly is "Death by SQL". Don't do it... period.

Outstanding! Thank you for the feedback!