Viewing 15 posts - 45,496 through 45,510 (of 59,063 total)
Grant Fritchey (1/26/2009)
Two possible answers, both will work:TOP
ROW_NUMBER
Simple MAX would do it...
January 26, 2009 at 7:47 pm
CHAR(0) is the NULL character... remember what happens with nulls... same thing here.
January 26, 2009 at 7:42 pm
ah.nasr (1/26/2009)
set @count = 0select quantity from .....
while @count < quantity
begin
set @count = @count + 1
insert .......
end
Heh... try THAT on a million invoices...
Lowell has it right with the Tally...
January 26, 2009 at 7:38 pm
Helmut, since your relatively a "newbie", I'll be nice... there's really no quicker way to tick off the alumni on this forum than "duplicate posting". Just pick the correct...
January 26, 2009 at 7:32 pm
kasper (11/16/2006)
Hi,Did anybody compare the performance of scripting operations with SQL-DMO vs SMO? What other reasons should be considered, to choose between two solutions?
Thanks.
Heh... now wait just a cotton-pickin'-minute ;)......
January 26, 2009 at 7:25 pm
If you have VB, you could convert the script to a CLR... I'm sure there's other ways, but I don't know what they are.
What I'd be more interested in finding...
January 26, 2009 at 7:21 pm
Where are you doing this at? No such dashed line appears in SMS in the Text Mode.
January 26, 2009 at 7:18 pm
DB_Newbie2007 (1/26/2009)
January 26, 2009 at 7:16 pm
Jeff Moden (1/26/2009)
Also, will that snippet of code tell you...
January 26, 2009 at 6:41 pm
I agree with Gail... be very careful about removing indexes just because they haven't been used in a week or two.
Also, will that snippet of code tell you if the...
January 26, 2009 at 6:36 pm
Ratheesh.K.Nair (1/23/2009)
Hi Experts,Can anyone please help me in giving assignments to DBA trainees.They need to know from scratch. What type of assignments have to give them?
TIA
First thing taught in most...
January 26, 2009 at 6:26 pm
A call to BCP with a format file would probably have a whole lot more performance.
January 26, 2009 at 6:19 pm
... or a negative number or something that won't convert to an INT.
January 26, 2009 at 6:06 pm
Gift Peddie (1/26/2009)
Update using the FROM clause violates JOINs are idempotent rule in relational algebra.
Heh... ummmm... so what? Cursors violate the whole idea of a database but they continue...
January 26, 2009 at 5:53 pm
Thanks for the feedback, Tony. And, anyone who wants to learn more about how a Tally table works to replace some loops, here's a pretty good (heh... if I...
January 26, 2009 at 5:50 pm
Viewing 15 posts - 45,496 through 45,510 (of 59,063 total)