I agree. I was just considering re-writing this to manually list all of the...

Thanks Matt. I've always known you could Schema Bind a view, but I've never needed to, so I didn't consider the reasons why you might do so. In...

If that's the case, then any time the definition for Table1 changes, that view will have to be altered, unless there is another option that I can set...

See the link in my signature for Jeff Moden's article on Cross-Tabs. Should solve this handily.

I'll start it off with one that is fairly basic but many may not know about.

Creating a temp / staging table that mirrors a real table for data selection.

SELECT *

INTO...

Create your second server as a linked server on the first. (See http://msdn.microsoft.com/en-us/library/aa213778(SQL.80).aspx for more information)

Then, you can reference the other server and the current one in the same query.

For...

Is that ever the case though? =).

In addition to what Steve has requested, please see the article in my signature on how to provide sample data.

There's a mini debate of COALESCE vs. ISNULL going on in the concatenating NULL values thread. I believe the consensus is that ISNULL is in fact faster, but COALESCE...

He's just carrying forward the serial number whenever the DocumentID is 'H'. Easily solved by Running Totals.

William, please observe the way I posted your sample data. Please duplicate...

PW (1/15/2009)

---

I'll take a break from gnashing my teeth & swearing at the original coder to add my common mistake:

Frequent use of DISTINCT to hide a fundamental design flaw and/or...

Isn't the point of that whole debate that the optimizer can do what it wants? While the test code may demonstrate certain characteristics, is anyone certain that another query,...

No problem Andy, glad we could help.

It is my understanding that the only thing that it will hold true 100% of the time as far as that goes is a case statement. This issue has...

What is the datatype of QuoteHrs.Item?