Viewing 15 posts - 57,196 through 57,210 (of 59,066 total)
Yeah... and how many rows did you ultimately end up with?
November 29, 2006 at 9:01 am
Hang the typo's!! There aren't that many and it's very obvious what they are/should be. Heck, I've seen more errors in published books that have supposedly been professionally proof-read and...
November 29, 2006 at 8:39 am
This looks like a homework question and you are trying to get someone else do the work.
I'll drink to that!![]()
November 28, 2006 at 10:02 am
Steve,
I gotta ask... you're saying that you basically want to copy all of table A into table B 10 times (regardless of the loop you requested)???
November 28, 2006 at 9:53 am
Why?
Not trying to be a smart guy here but why do you want to do such a conversion? A lot of times,...
November 28, 2006 at 9:44 am
That, my old friend, is the reason I won't bet you... neither of us got this far being the fool... ![]()
November 28, 2006 at 6:48 am
Only after I know the answer for sure ![]()
November 27, 2006 at 6:34 am
Nothing a little self join correlated subquery magic can't fix... works in the grid or text modes...
--===== Supress the auto-display of rowcounts for appearance
SET NOCOUNT ON
November 27, 2006 at 1:07 am
| The alternative is to write a query instead an "on the fly" ad hoc mess. |
So, how do...
November 27, 2006 at 12:50 am
Are you sure that would be true in this case? A trip to the disk should always turn out to be slower than a relatively simple trig calculation...
November 26, 2006 at 10:48 pm
Not if you're using a constant for a multiplier on latitude... if you are not using a Cosine based formula, it does not take the curvature of the Earth into...
November 26, 2006 at 6:23 pm
Yeah... especially since I might use my pickup to pull a santion out of the building just to get their attention ![]()
November 26, 2006 at 4:32 pm
Yep... I forgot those... the security concerns, that is. If you are using stored procs, the users don't need huge privs to use the program as they would with embedded...
November 25, 2006 at 3:40 pm
I agree... there's still some info missing...
Brian, are you simply saying that you want to be able to update any row and insert new rows from the app?
Or are you...
November 25, 2006 at 3:36 pm
Viewing 15 posts - 57,196 through 57,210 (of 59,066 total)