Viewing 15 posts - 52,726 through 52,740 (of 59,064 total)
don't really see the point of an unique index with ignore duplicates on. Am I missing something?
It's a cheater method for removing dupes during a Bulk Insert or BCP.
...
January 23, 2008 at 6:43 pm
It was, indeed, a good post!
Just an FYI... I'm not sure how to do it myself, but the hardware boys in our shop found out that the EMC Clarion is...
January 23, 2008 at 6:35 pm
djiang (1/23/2008)
I'm trying to insert a string into a temp table. For instance I want a nvarchar(4000) string
@Ids inserted as separte Ids in a All_id table.
The user can type...
January 23, 2008 at 6:12 pm
From the description, the code looks correct... did you try it?
January 23, 2008 at 4:40 pm
I guess I don't understand... if a conditional expression will always result in TRUE, why have the conditional expression to begin with? What am I missing here? Keep...
January 23, 2008 at 4:29 pm
Nice reference link, Todd... thanks.
January 23, 2008 at 7:28 am
I was thinking the same thing... 😉
Also, Matt... your the Ninja on Regex... is there anyway to use Regex for such a thing as this import?
January 23, 2008 at 7:26 am
Very cool... with your great instructions, I'll just bet I learn something new! Thanks, Adrian...
I'll bet the OP will like it, as well!
I'll still take a brute force...
January 23, 2008 at 7:11 am
And, I haven't done the comparison lately, but I believe the first method I showed will be the pants off most outer join methods...
January 23, 2008 at 7:06 am
Absolutely agree... if the numbers table is large enough... if it's not, then you can do something like the following...
... Also, in 2k5, you really don't need a recursive CTE...
January 23, 2008 at 7:04 am
Thanks for the feedback, Phil. Really appreciate your comments.
By the way (almost forgot)... they haven't fixed the code windows on this forum, yet. If you just copy and...
January 23, 2008 at 6:51 am
Holtis,
That's a good question... what is the 1/1/1/20008 notation? Is it real or just a cut and paste error?
January 23, 2008 at 6:45 am
Certainly not... but I don't use DTS or SSIS for several reasons... wanna give it a try for us? Because I don't use it, I wouldn't know where to...
January 23, 2008 at 6:23 am
Nice.... just be a bit careful... haven't tested it but it looks like if the serial numbers are large, that'll take a while to resolve.
January 23, 2008 at 6:09 am
Yes... not only is it possible, but it's a frequent recommendation... just change the SET ROWCOUNT value to what you want in the code that follows... note that this is...
January 23, 2008 at 5:50 am
Viewing 15 posts - 52,726 through 52,740 (of 59,064 total)