Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
2
Impact
~13k people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
Sep
24
awarded  Autobiographer
Mar
16
answered Why aren't primary key / foreign key matches used for joins?
Feb
24
comment Complex SQL query - need help
@Jack, That basically an SP.
Feb
24
comment Complex SQL query - need help
What if a new table is created and you need to add rules for it? You need to modify your SQL. There is just too much overhead here to attempt to do this with one query.
Feb
24
comment Complex SQL query - need help
I mean an SQL query.. you can do this with an SP. Following my Logic. The Table the you need to join to is stored as Data (tablename). (The field is also stored as data). So you would need to Join to all those Tables with a where clause for TableNAme.
Feb
24
awarded  Teacher
Feb
24
answered Complex SQL query - need help
Feb
14
answered Is it a good idea to use Synonyms to avoid creating a duplicate table?