If there's nothing that violates privacy laws or company policy, post the first ten lines of data so we can resolve this correctly, please.

This would be a good simple example for you to practice set based programming on... convert the cursor to set based.

The real fact is, you don't need BEGIN/END in a stored procedure. Try it... it's just allowed to make die hard Oracle programmers happy 😛

No... that's why the column number is "0". Read up on BCP Format Files... especially the example about skipping unwanted columns.

I'm with Steve... I use mixed case... it enforces capitalization and it's easier to hit the shift key than it is to hit the underscore when typing.

I agree with the...

You didn't answer the question... What is it that you want to do and why do you think you need to modify the system tables...

As a DBA, you shouldn't... there's not much that can't be done in T-SQL with the possible exception of RegEx (Regular expressions) and, despite what Books Online says about the...

You CANNOT rely on the "% of Batch" listed in estimated or actual execution plans to determine which query is best... it can "lie" because it can't always see everything......

Doesn't even need to be SSIS... can be some decent stored procs. But the point is an excellent one...

UDF's are typically RBAR...

Heh... It's amazing to me how many undocumented databases there are in the world. It also amazes me how many there are with no DRI... no DRI means no...

Step 1 should be to nomalize the table so things like this become much easier.

The real culprit is likely going to turn out to be a deadlock. You need to read "Deadlocks, detecting and ending" in Books Online. Pay particular attention to...

SQLElhassan (1/11/2008)

---

Thanks guys and specially GSquared,

The Numbers table worked perfectly for me but I want to have my leading zero back in the PK field. Like I explained above, I'm...

As...