Viewing 15 posts - 23,446 through 23,460 (of 26,490 total)
Also, if I remember the discussions around Jeff's article on running totals, the only place he has run into difficulties with the technique is with partitioned tables. That is...
November 27, 2008 at 3:42 pm
Okay, can't wait to see Jeff's response. I was using a technique I picked up from him for completing running totals.
Regarding storing running totals, maybe it isn't stored in...
November 27, 2008 at 3:01 pm
Hugo Kornelis (11/27/2008)
Lynn Pettis (11/27/2008)
Since the purpose of the identity field was order, if there was a gap it wouldn't have caused an issue.
Hi Lynn,
But you are using the IDENTITY...
November 27, 2008 at 2:03 pm
diehc (11/27/2008)
I have that compare 2 tables (table1 and table2), if tne rows of the table1 dont exist in table2, have to inserted then in table2 , but if there...
November 27, 2008 at 12:36 pm
Jeff Moden (11/27/2008)
Lynn Pettis (11/26/2008)
Good article, but let's take another approach and see what we see.Heh... you beat me to it, again. 😉
Heh... I may be old, but I'm...
November 27, 2008 at 11:11 am
jacroberts (11/27/2008)
Lynn Pettis (11/27/2008)
jacroberts (11/27/2008)
timothyawiseman (11/27/2008)
jacroberts (11/25/2008)
timothyawiseman (11/24/2008)[hr
This is true, for a small number of rows. Your RBAR TVF will become ineffecient should requirements change and the number of...
November 27, 2008 at 10:48 am
Paresh Prajapati (11/27/2008)
November 27, 2008 at 10:16 am
Julio Conejo (11/26/2008)
November 27, 2008 at 10:12 am
jacroberts (11/27/2008)
timothyawiseman (11/27/2008)
jacroberts (11/25/2008)
timothyawiseman (11/24/2008)[hr
>>The problem is that your example did not show a case where efficiency is not a concern.
>>But, in your example you say there is no need...
November 27, 2008 at 9:58 am
I'll address a couple of concerns from my point of view.
1. Based on the article, the first 4 values should be zero. This is why I put an isnull...
November 27, 2008 at 9:51 am
Good article, but let's take another approach and see what we see.
Taking your sample data from your article, and using a slightly different tact, here is another way to tackle...
November 26, 2008 at 11:53 pm
No. I said to ignore that backup. Scenerio:
Day 1 ...
November 26, 2008 at 11:19 pm
Actually, I think that is what we are all waiting for.
November 26, 2008 at 9:45 pm
I am unaware of any articles that I could point you toward. Your best bet would be to look at some of the books on database design or data...
November 26, 2008 at 9:42 pm
Could it be he is trying to drop multiple databases? Only the OP knows for sure.
November 26, 2008 at 8:44 pm
Viewing 15 posts - 23,446 through 23,460 (of 26,490 total)