And if you have something like:

1 A B C

2 A D...

FNS

---

Personally I think on the whole it's done out of laziness and sloppy coding practices. I know that sometimes it's an invaluable tool but it shouldn't be used first...

You'll need to use something like SSRS or Crystal Reports for that.

I've prettymuch gotten nowhere with testing these different methods. They all show negligible differences

in times, regardless of both the amount of data being used and the density of the...

Yeah, all 3 of us assumed you did that =).

Proper syntax is ServerName.Databasename.Owner.ObjectName. You are seeing DatabaseName..ObjectName and letting it automatically fill in the owner name, which either always attempts dbo, or attempts based on the current user...

Please post the code that you attempted that did not work. Second, please post sample data / table inserts according to the link in my signature. Third, please...

Is your end goal here to get the data into 1 table for the future, or simply to build a query that will read from these 44 (and ever growing)...

I was kinda hoping you'd come to that conclusion :P.

We'll likely be generating a dynamic column list for the final select, as well...

I'm looking at having to use...

I've done some testing, not quite happy that I've covered it all yet, but I'll finish it up tonight when I get home. So far, a couple...

This is a guess based on your above query. This may or may not return the correct results, as this is completely untested.

[font="Courier New"]SELECT     Customers.CustomerName,

               SalesOrders.SalesOrderId,

               ProgressPayments.PaymentDate,

               ProgressPayments.InvoiceValue AS...

I wasn't really relying on the percentage of batch in this case, merely noting the differences. The thing that really makes no sense to me, and seems...

Jeff Moden (10/13/2008)

---

Garadin (10/12/2008)

---

The execution plans are the same, but the percentages skew slightly. The join query has 235 reads as opposed to 156 for the IN. Unfortunately...

Could you post some sample data / table defintions that we can run?(See the link in my signature for an example if you don't know what I mean by this)...