Viewing 15 posts - 52,951 through 52,965 (of 59,068 total)
k.furness (1/12/2008)
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...
January 12, 2008 at 9:29 am
Heh... go around talking like those words, and you'll be labeled as pompous a$$ for sure...
January 11, 2008 at 9:55 pm
If you have an answer to this, Ananth, just tell us... 😉
January 11, 2008 at 9:40 pm
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.
January 11, 2008 at 9:38 pm
This would be a good simple example for you to practice set based programming on... convert the cursor to set based.
January 11, 2008 at 9:35 pm
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 😛
January 11, 2008 at 9:22 pm
No... that's why the column number is "0". Read up on BCP Format Files... especially the example about skipping unwanted columns.
January 11, 2008 at 9:19 pm
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...
January 11, 2008 at 9:16 pm
Raghavender (1/11/2008)
Thank you for your reply
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...
January 11, 2008 at 9:13 pm
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......
January 11, 2008 at 9:01 pm
Doesn't even need to be SSIS... can be some decent stored procs. But the point is an excellent one...
January 11, 2008 at 8:36 pm
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...
January 11, 2008 at 8:29 pm
Viewing 15 posts - 52,951 through 52,965 (of 59,068 total)