Viewing 15 posts - 52,801 through 52,815 (of 59,070 total)
remember this code was done based on BOL examples, but I don't remember the topic.
First, nice idea... hadn't thought about doing it that way. Great way to import...
January 18, 2008 at 7:07 pm
Sergiy (1/14/2008)
Using "," as delimites is an error waiting to happen.
mdjtlj, ask you supplier to build a test file containing '19" Monitor'.
Then try to process that...
January 18, 2008 at 7:05 pm
My question is: is there any way I can achieve this goal without the GROUP By phrase?
I could be wrong, but I don't think there is...
January 18, 2008 at 6:33 pm
Alter table won't support a 4 part naming convention, anyway... object functions and Alter table all support 3 part naming conventions... why not use them?
January 18, 2008 at 5:19 pm
If you have 20 columns in table A, and you try to list all 20 columns in the presence of a COUNT, then you must list all 20 columns in...
January 18, 2008 at 5:13 pm
Shoot... I hope I didn't just help someone do their homework without them trying themselves, first...
January 18, 2008 at 5:08 pm
This will do it... assuming that names are unique...
--===== Simulate the OPs table
-- This is NOT part of the solution
DECLARE @yourtable TABLE
...
January 18, 2008 at 5:06 pm
Thanks... that's half the battle... 😉
Do you have any documentation on the record layout of the file you intend to import? And can you attach a file with,...
January 18, 2008 at 4:40 pm
Heh... yep, I knew that Michael... sorry I didn't state things clearly... I wanted to know the condition of the OPs data.
January 18, 2008 at 12:53 pm
Just curious... I can see where a NULL end date could be interpreted as 31 Dec 9999, but what does a NULL start date indicate other than something hasn't started?...
January 18, 2008 at 11:04 am
GSquared (1/18/2008)
January 18, 2008 at 10:59 am
Very good comprehensive article. I just don't understand why a simple BULK INSERT couldn't be used to populate a temp table...
January 18, 2008 at 10:57 am
If I remember correctly, @@IDENTITY has all the potential problems you describe including grabbing from the wrong table in the presence of triggers. I've never seen Scope_Identity fail in...
January 18, 2008 at 8:20 am
No, no... you have to eat the boards if you use that word 😛
January 18, 2008 at 8:15 am
Dang! You're spot on! I DO have better things to do than to help you. Thanks for the advice 😉
January 18, 2008 at 8:11 am
Viewing 15 posts - 52,801 through 52,815 (of 59,070 total)