Viewing 15 posts - 53,491 through 53,505 (of 59,064 total)
Yeah, you could... but who cares? So long as the code executes correctly, you may not need to see it.
Under {Tools}{Options}, click on the [Results] tab and see what...
December 19, 2007 at 2:03 pm
The LIKE will be just a tiny bit faster in this case because it returns only the rows that have precisely 3 digits... the LEN()<9 will return things that have...
December 19, 2007 at 1:56 pm
Heh... on the other side of the coin, how do you know it's not broke unless you try to fix it. 😉
December 19, 2007 at 1:46 pm
You mean like doing the SELECT/INTO from a "derived" table with a "Top 100 Percent"... dunno... haven't tried that, but I will 😉
December 19, 2007 at 1:44 pm
How are you viewing the code? If it's in Query Analyzer, it may just be a view setting under Tools Options.
You can concatenate about 256 8k variables for an...
December 19, 2007 at 1:35 pm
I do wish they'd go back to a forum specific search...
December 19, 2007 at 1:25 pm
See what I mean, Marcus? No... no one wrote 100% of the code you needed... but, unless I miss my guess, David's code will be very easy for you...
December 19, 2007 at 1:23 pm
Sorry... I didn't say it quite correctly... if the table is preformed with an IDENTITY column, you'll be ok... it's actually when you use the SELECT/INTO with the IDENTITY function...
December 19, 2007 at 1:00 pm
The table name cannot be variable without using some form of dynamic SQL... kinda like...
DECLARE @TableName SYSNAME
SET @TableName = 'sometablename'
EXEC ('SELECT * FROM ' + @TableName)
December 19, 2007 at 12:13 pm
Thanks for the feedback, Matt...
I suppose the reason why I only got 40% improvement out of SELECT/INTO is because I'm running an "ancient" 5 year old P5 running at...
December 19, 2007 at 12:02 pm
grkanth81 (12/19/2007)
Hey guyz...can anyone help me with the probs i have mentioned in the post...
thnx...
Well, at least that's a polite way to "bump" your post... 😉 This isn't "instant...
December 19, 2007 at 11:49 am
Oh, sorry... yes, your query is the ticket... mine is wrong.
December 19, 2007 at 11:15 am
Perhaps, something like this...
select first_name
,last_name
,government_id
from people
where government_id like '[0-9][0-9][0-9]-%'
December 19, 2007 at 11:03 am
... and no... I don't recommend using two loops 😛
December 19, 2007 at 10:37 am
Viewing 15 posts - 53,491 through 53,505 (of 59,064 total)