Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
benildusmuerling
Yak Posting Veteran
81 Posts |
 Posted - 2012-07-05 : 04:24:14
|
| Hi All,Would anyone like to help me to say, that I am going through a coding which there is 2000 lines of code, only in returning 14 number of rows.Wouldnt there be another way in writing the code completely.The other thing I would like to ask about would be, a table with 6 composite keys, isnt it an identification of a poor database design.Thanks,Antonio |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-07-05 : 04:30:17
|
There is no relation between lines of code and number of rows.select * from tablecan return a million rows or nothing...A table with 6 composite keys sounds interesting but I don't know if that is an indicator for a poor design.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
A table with 6 composite keys