Look up UNION or UNPIVOT in BOL.

Maybe. What I heard of MSSQL from Oracle DBAs is that they...

I've seen very little of that "O" thing, but, so far, that's the best...

Thanks, Paul. The Oracle forums here on SSC seem to be a...

Looks like a good place for Merge Replication.

http://technet.microsoft.com/en-us/library/ms151329.aspx

Try specifying the database name in the query:

SELECT * FROM <database>.<schema>.<table>

Tom.Thomson (5/31/2010)

---

GilaMonster (5/30/2010)

---

Actually from one point of view this is a smaller problem than the other. Working out a backup strategy for 2TB of data is non-trivial, so it's...

If you want data ordered in a particular way, add ORDER BY to your query.

UNION doesn't enforce a particular order in the concatenated sets. Indeed, UNIONs are performed internally as...

Yes, the device CAL allows you to install client tools for all licensed devices, no matter what kind of operations you perform on the server.

Do you have a single index on both Customer and OrderNo or two separate NC indexes?

It's a crazy requirement.

IE can't open on the client machine, but would only run on the SQL server machine. Is that really what you want?

Can you explain exactly...

GilaMonster (5/26/2010)

---

Ow, losing your patience...

Who? You mean this individual?

Bananas. :hehe:

Stands for bytes, obviously! Can you figure out any other unit to measure row size?

BOL states:

At first I thought...

Common sense is in spite of, not the result of, education.

-- Victor Hugo