Forum Replies Created
Viewing 15 posts - 57,181 through 57,195 (of 59,049 total)
-
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...
-
RE: Modify the Auto Number
If it's the Primary Key, then you may be (will be) destroying referential integrity for other data in other tables. If it's the Primary Key and you don't have referential integrity,...
-
RE: what t-sql command assigns and returns a unique id simultaneously?
I'd never use @@Identity because it is not scope sensitive and, in the presence of triggers, will surely return an incorrect value. Always use SCOPE_IDENTITY for such a thing.
Viewing 15 posts - 57,181 through 57,195 (of 59,049 total)