Viewing 15 posts - 50,446 through 50,460 (of 59,078 total)
As I said earlier, you have to define what "first" means first... what do you consider to be the correct order of the data? Can't help unless we know...
May 19, 2008 at 6:03 am
In this case, since the same amount of data is being transmitted either way, it would probably be best to tax the client for the final format instead of having...
May 19, 2008 at 6:00 am
Michael Earl (5/19/2008)
I have never had to do anything with the firewall, so I think the answer is no.
Thanks, Michael... when I get a chance, I'll undo the exceptions I've...
May 19, 2008 at 5:53 am
Tally table join with MonthEnd calculation on "N" should do it. Give it a try... 😉
May 19, 2008 at 5:49 am
peitech (5/19/2008)
Note that [ABCDEFGHIJKLMNOPQRSTUVWXYZ] <> [A-Z] since [A-Z] = [AbBcCdD...zZ], confusingly!
I didn't know that, but it does make a lot of sense with something I was just doing - so...
May 19, 2008 at 5:38 am
I never think my function leads to RBAR. How to find it ?
The function is executed once for every row that is returned in the SELECT list... since the function...
May 19, 2008 at 5:34 am
Mybowlcut (5/18/2008)
Why do you need to do this? It may make a difference...
What do you mean? It's part of an assignment. Please don't say this is a "homework question"...
May 19, 2008 at 4:49 am
The question you asked was why was the copy/query to a heap so much faster... I answered that. If you put the index on the original table that Lynn...
May 18, 2008 at 6:22 pm
Anirban Paul (5/14/2008)
Readability comes from indentation and usage of space not from smaller case or capital case.
Just for the record, I strongly disagree with that and that's why I...
May 18, 2008 at 5:40 pm
I suppose... instead of doing an UPDATE using the method I suggested, it could be just a SELECT as part of the view.
The real question would be, what are you...
May 18, 2008 at 10:50 am
Shifting gears a bit, Barry... do you realize the link in your signature line is broken?
May 18, 2008 at 10:47 am
Way too funny! 🙂 Heh, I guess THAT's why Steve limits the size of the Avatars :hehe:
May 18, 2008 at 10:44 am
Michael Meierruth (5/18/2008)
If your transaction log is 'going to blow' it will do so with or without the delete crawler. Nevertheless, check your db recovery mode setting.
Good catch... I should...
May 18, 2008 at 10:36 am
Nicely done… Recursion is fine for ad hoc hierarchical lookups, but, if I may suggest, using recursion to "step through" things, like that which occurs in a "split", is...
May 18, 2008 at 10:17 am
Heh... 😛
Just a simple demonstration to show just how slow recursion can be. Let's populate a table with the number of 1 to 100,000... first method uses recursion... second...
May 17, 2008 at 8:39 pm
Viewing 15 posts - 50,446 through 50,460 (of 59,078 total)