Re: Reference temporary table twice

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Quick stupid answer: Your two outcomes are not structured the same.
Tables have fixed known structures by DEFINITION. You never read a
book on RDBMS, have you?

Have you heard the phrase "Automobiles, Squids and Britney Spears"
used to refer to non-relational design problems in DDL and DML? It
means you have a stew of unrelated things in one table or query. What
you have done is map:

Automobiles = Personnel. RDBMS would not use Employees because tables
are sets and not lists. This alone tells me your schema is a mess.

Squids = Suppliers.

Did you ever learn about coupling and cohesion? That is basic
software engineering and far, far more fundamental than declarative vs
procedural code. Stop programming until you do.

What you are doing is writing a 1950's magnetic tape file that
PHYSICALLY moves data from PHYSICAL location to PHYSICAL location.
But you are not even a good file system programmer.

You will get Kludges here for putting the totally un-related data
elements "emp_last_name" and "company_name" into one column because
they are both VARCHAR(n) ? Hey, add street names!!

Do you want to be a professional or not?






.

Relevant Pages

  • Re: Copy Row Of Data From Table to Table In Same DB
    ... Let us go back to RDBMS basics. ... In the old days, with punch cards, paper files, etc. we would ... physically move these physical records from one physical location to ... relational key. ...
    (comp.databases.ms-sqlserver)
  • Re: Pass Table as a parameter to a function
    ... Please read a book, any book, on data modeling, and RDBMS. ... magnetic tape file system instead of an RDBMS. ...
    (comp.databases.ms-sqlserver)
  • Re: Pass Table as a parameter to a function
    ... Please read a book, any book, on data modeling, and RDBMS. ... super function that works on Squids, Automobiles, Britney Spears, ... magnetic tape file system instead of an RDBMS. ...
    (comp.databases.ms-sqlserver)