Viewing 15 posts - 1,951 through 1,965 (of 4,080 total)
There is no need to do a cursor. All you have to do is specify the operation(s) you want to perform to the entire set of rows....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 8, 2009 at 6:34 am
Good to know, I suppose, but why are you declaring the variables inside a loop? That seems like an odd practice to me, and I just wondered about...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 7, 2009 at 11:54 pm
I was assuming that it would be acceptable to just generate a new table from the old rather than do a series of updates using the result set. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 7, 2009 at 11:48 pm
The following code will work, assuming the company name is consistent between all rows. For future reference, please include the declare statement and the inserts when you are...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 7, 2009 at 9:30 pm
I'm not a Newfie!!! I'm from Nova Scotia.
Doesn't Newfoundland have it's own time zone?
It's 27.5 minutes ahead of Nova Scotia or something like that.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 7, 2009 at 2:47 pm
"Newbies?"
I thought he said "Newfies".... and was talking about Alvin! 😛
By the way, Steve, I ready the journey/destination reply and thought it was brilliant.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 7, 2009 at 2:40 pm
At least he put it in the Hardware section of the Forums....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 7, 2009 at 11:13 am
I'm not a number, I'm a free man !!!
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 7, 2009 at 9:16 am
Spam emails: The preferred method of getting your questions moved to the head of the line when URGENT isn't working for you. I'm not even the target...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 7, 2009 at 8:26 am
"FELLOW experts???"
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 7, 2009 at 8:22 am
And that would be to see if they also said: "Please hurry"?
We should test that:
SET STATISTICS TIME ON;
SELECT "Urgent! Please hurry!"
SET STATISTICS TIME OFF;
Hmmmm.... on my laptop it reduces...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 7, 2009 at 8:18 am
Now if they had said "Help me with this, please, Expert." that would have been another matter entirely. 😉
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 7, 2009 at 7:51 am
Visions of William Shatner in Airplane II: The Sequel.
I thought it was Lloyd Bridges.
Bru: Lynn is correct.
If I post something that seems odd, assume that...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 4, 2009 at 9:55 am
This isn't the right thread for technical questions. I'd move it to one of the usual forums.
No.... that's just what they'll be expecting us to do..... :smooooth:
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 4, 2009 at 9:28 am
Is it stopping early or skipping levels of ancestors? Possibly a join isn't finding a match? We'd need to see source data in all the tables...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 26, 2009 at 12:40 pm
Viewing 15 posts - 1,951 through 1,965 (of 4,080 total)