Viewing 15 posts - 48,886 through 48,900 (of 59,065 total)
drari (8/6/2008)
he gives a totalrows = 7
Maybe there is a way to...
August 6, 2008 at 8:30 am
Yep... And I looked at that file... it's just like I said... the header record and the trailer record both have a different number of columns than the body of...
August 6, 2008 at 7:38 am
Um... ok... a bit out of the ordinary...
Click on my name above my avatar to the left and send me an email with the file attached.
Folks, if I find something,...
August 6, 2008 at 7:11 am
From the description of things, it sounds like you have some code somewhere that makes tomorrow's database today... maybe, in more than one spot. I'm thinking that all you...
August 6, 2008 at 7:03 am
Only one thing left to do, then. Attach the create script for the target table, the BCP format file, and, if there's no private information in it, the file...
August 6, 2008 at 6:44 am
There are a huge number of rules for the partitioning column and the partitioned table in Books Online... my recommendation would be to make a checklist of what needs to...
August 5, 2008 at 11:22 pm
The WHILE condition doesn't make sense for the code you posted... it will run forever because something will always exist in the table.
Also, you're trying to insert into the same...
August 5, 2008 at 11:12 pm
Thanks for the feedback, Jim.
August 5, 2008 at 10:18 pm
The header must have exactly the same delimiters as the 2nd row which must match all the other rows, or BCP will give you that error and the 2nd row...
August 5, 2008 at 10:13 pm
Amit Chaudhary (8/5/2008)
I think I am asking this question in the right forum.
THe configuration on my server is TCPIP Enabled, Named Pipes Enabled. The order of SQL Native CLient Protocols...
August 5, 2008 at 10:10 pm
How many rows are you talking about copying? I'm thinking that you don't actually need the WHILE loop because of the explicit transaction you've declared. Use set based...
August 5, 2008 at 10:04 pm
Gareth (7/31/2008)
I was asked to investigate the possibility of table partitioning by a developer.
I used a 7 gig...
August 5, 2008 at 10:00 pm
And, if you don't mind, tell us why it has to be a dynamic column name. 😉
August 5, 2008 at 9:57 pm
Index... maybe a partitioned table, to boot.
August 5, 2008 at 9:54 pm
Or... you can beat the crud out of a string anyway you like... 🙂 CREATE FUNCTION dbo.udf_Extract
/*******************************************************************************
Purpose:
========
Removes unwanted characters from a string.
Notes:
======
Possible inclusive values...
August 5, 2008 at 8:41 pm
Viewing 15 posts - 48,886 through 48,900 (of 59,065 total)