Viewing 15 posts - 48,991 through 49,005 (of 59,065 total)
Michael,
Although using a WHILE loop to split a string is a tried and true method, it's relatively slow compared to other methods. Please see the following two articles... they're...
August 1, 2008 at 5:55 pm
Manie Verster (8/1/2008)
August 1, 2008 at 5:26 pm
Vampire (7/31/2008)
Sql Server doesn't allow us to capture the rows returned by a Sproc since Sprocs dont have ability to return a result set.
Absolutely not true in SQL Server... ;)...
July 31, 2008 at 6:57 pm
I have no idea how to troubleshoot, never mind even write a CLR. But, I am interested in what your UDF does... if you don't mind.
July 31, 2008 at 6:40 pm
Yeaup! I agree with Sergiy... The file should only contain delimited data and then use either BCP or BULK INSERT to import the data. See Books Online for...
July 31, 2008 at 6:28 pm
What a great set of "mini-courses" you're in the process of having published! Nicely done!
My only question on this one would be... why would you ever teach anyone to...
July 31, 2008 at 6:21 pm
Heh... of course it's a perfect solution... but only for what it was designed for... it's an IsAllDigits function and wasn't meant to be anything else. If you want...
July 31, 2008 at 5:41 pm
Steve Jones - Editor (7/31/2008)
You should get clarification from MS. They can be funny about this.
My understanding is you can use Dev for yourself, but everyone else needs a CAL...
July 31, 2008 at 9:10 am
Thanks for the clarifications, folks... between what has already been posted and what I found at the links included in the following, it turns out that you can have as...
July 31, 2008 at 9:08 am
Outstanding, Ian... that's just what I was looking for. Thanks for the very quick reply, too!:)
July 31, 2008 at 8:44 am
kubilay husmenoglu (7/31/2008)
Hi, I have exactly the same problem with OSQL.Does anybody has a solution
I'd recommend you start a new thread for this... it'll get more attention.
July 31, 2008 at 4:58 am
Ross McMicken (7/31/2008)
July 31, 2008 at 4:54 am
Oh, yeah... almost forgot... "In the land of the blind, the one eyed man is King!"... That's why most people look at the Execution Plan and believe in it. ...
July 30, 2008 at 9:32 pm
I may have to write an article about it someday... I've found that WHERE NOT IN beats the OUTER JOIN type of exclusion, WHERE NOT EXISTS correlated subqueries, and a...
July 30, 2008 at 8:50 pm
Heh... reminds me of a dictionary... how can you check the spelling on a word using a dictionary without a bit of luck?
I agree with Matt... UNPIVOT is...
July 30, 2008 at 8:44 pm
Viewing 15 posts - 48,991 through 49,005 (of 59,065 total)