k.furness (1/12/2008)

---

Hi Jeff

This is single table that contains the following Fields:

ID [int] Identity

QuestionnaireID [int]

Q0 [smallint]

.

.

.

Q150 [smallint]

Don't think I can get it any normalized than it is, but if I...

Actually... wasn't talking to him... 😉

Heh... go around talking like those words, and you'll be labeled as pompous a$$ for sure...

If you have an answer to this, Ananth, just tell us... 😉

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...