Viewing 15 posts - 4,276 through 4,290 (of 8,731 total)
I'm starting to hear some crickets. 😀
September 3, 2015 at 10:07 am
halifaxdal (9/3/2015)
The data row contains comma in one of the column, which makes the bcp thinking it is a delimiter.
Maybe I need to re-generate the data by...
September 3, 2015 at 10:06 am
Include the max errors option with a large number that will be enough for all the errors.
Don't remove the -e option so you can troubleshoot the problem later.
-m max_errors
Specifies the...
September 3, 2015 at 10:04 am
The version is repeated in the format file. Delete one of them.
9.0
7
1 SQLCHAR 0 128 "," ...
September 3, 2015 at 9:35 am
It could be with something like this:
CREATE TABLE numerator(
memberid int,
measureid int
);
INSERT INTO numerator
VALUES
(1,501),
(1,502),
(1,503),
(2,501),
(2,502),
(3,501),
(3,501),
(3,501),
(3,501),
(4,501),
(4,502),
(4,503),
(4,504),
(4,505);
SELECT memberid,
measureid
FROM numerator
WHERE memberid IN...
September 3, 2015 at 9:29 am
Lord Lucan (9/3/2015)
haha, thanks all.I think I like it here already
If you appreciate your sanity, avoid it. I didn't :hehe:
Welcome aboard! I hope that you'll be able to learn a...
September 3, 2015 at 8:34 am
Your format file is still wrong, and this is because you create it from the table instead of creating it from the file. The file doesn't have the id column,...
September 3, 2015 at 8:25 am
I usually avoid the money data type because it has some weird rounding issues. I prefer to use decimal in general. You can google for advantages and disadvantages on both.
Here...
September 3, 2015 at 6:13 am
I'd use the InsertSnippet option. That's precisely the functionality that snippets have.
You just need to create a new template.
September 2, 2015 at 2:36 pm
Your problem was that the table didn't match the file.
I suppose that that's what you found out (or maybe something we couldn't see).
I suggest you to read the following article...
September 2, 2015 at 2:16 pm
I would still encourage you to learn how to do this in Powershell or SSIS (DBAs prefer PoS, Developers usually go for SSIS). This will give you additional flexibility and...
September 2, 2015 at 1:48 pm
You're welcome. I hope that you had finally understood the code and what does it do on each step.
It would be "estoy". Use "estar" for something that denotes a temporary...
September 2, 2015 at 1:45 pm
Should I not call the procedure [spTryOutCreateFile] from [spTryOut] so that it can save the results from spTryOut
No, you should call [spTryOut] from [spTryOutCreateFile]. That's how it's coded.
[spTryOut] will return...
September 2, 2015 at 1:03 pm
This isn't a natural thing to do, but you should be able to get it done.
I might not have been very clear, but you need 2 stored procedures. One...
September 2, 2015 at 12:23 pm
whereisSQL? (9/2/2015)
Ed Wagner (9/2/2015)
crookj (9/2/2015)
BL0B_EATER (9/2/2015)
Ed Wagner (9/2/2015)
BL0B_EATER (9/2/2015)
SQLRNNR (9/1/2015)
spinelessbackbone
Accountability
responsible
liable
Law
Lawyer
Judge
September 2, 2015 at 10:29 am
Viewing 15 posts - 4,276 through 4,290 (of 8,731 total)