Forum Replies Created
Viewing 15 posts - 57,196 through 57,210 (of 59,066 total)
-
RE: Loop to insert in batches
Yeah... and how many rows did you ultimately end up with?
-
RE: New T-SQL Features in SQL Server 2005 Part 1
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...
-
RE: Plz solve me the queries
This looks like a homework question and you are trying to get someone else do the work.
I'll drink to that!
-
RE: Loop to insert in batches
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)???
-
RE: How do I cast the figure 2000.00 to the integer 2000?
Why?
Not trying to be a smart guy here but why do you want to do such a conversion? A lot of times,... -
RE: Sequential Numbering
Heh... better late than never...
-
RE: Using Variables / Parameters in a Select
That, my old friend, is the reason I won't bet you... neither of us got this far being the fool...
-
RE: Using Variables / Parameters in a Select
Only after I know the answer for sure
-
RE: Formating data
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
-
RE: Facing problem with executing large-value query variable
The alternative is to write a query instead an "on the fly" ad hoc mess. So, how do...
-
RE: Using Variables / Parameters in a Select
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...
-
RE: Using Variables / Parameters in a Select
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...
-
RE: Modify the Auto Number
Yeah... especially since I might use my pickup to pull a santion out of the building just to get their attention
-
RE: Creating a new table with a unique field
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...
-
RE: Update rows without using a cursor
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...
Viewing 15 posts - 57,196 through 57,210 (of 59,066 total)