My bad... they are UNION ALL in the Views.

Here is the rest of the post, part of the execution plan:

[/RelOp]

[RelOp AvgRowSize="75" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="3512.44" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="85" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="5.80676"]

[OutputList]

[ColumnReference...

Ok... here is the query:

SELECT

LO.Territory,

IV.AccountNumber,

CH.InvoiceItem, CH.InvoiceNumber,

CH.NetAmount,

CH.IncentiveAmount,

AD.[Name], AD.Company, AD.AddrLine1, AD.AddrLine2,

AD.City + N', ' + AD.State + N' ' + AD.PostalCode AS ConsigneeCityLine

FROM VIEW_CustTable CH --WITH(NOLOCK)

INNER JOIN...

Thanks for the info.... started looking into DMV(s) and I noted the comment in the BOL regarding the SHOWCONTIG command. Still learning (thrown into DBA position here last year).

I...

Ellis,

Thanks for the response! Unfortunately, on this server the databases tend to be pretty static during the week. There will be only one of two things happening:

1) Weekly...

To answer GSquared question, my experience is that derived tables (like the ones I used) or CTEs are not as fast or efficient being more "creative" with the query (as...

Just in case anyone is interested:

My query using all of the derived tables took 1 hour, 13 minutes to run.

Mark's query using the group/having clause took 14 minutes,...

Unfortunately, I believe that query will give me all customers in the database. I specifically need to find customers that have invoices in 2003, 2004, 2005, 2006 and 2007.

So,...

Fabio,

Thanks for your input and your concern.... who knows, maybe later down the line there will be some problem I am not cognizant of now?

The problem was...

Ok, in developing the code to convert all of the database tables that contain the FLOAT datatype fields to VARCHAR datatype fields, I discovered a solution to the initial QUERY...

Thanks everyone for your inputs!

Grant, I am impressed you were able to find that BOL entry. Either I am still not familiar enough with how to query BOL for...

Unfortunately, it is not that easy. 🙁

I tried to do LIKE '8810657712' and LIKE '8810657712%' and LIKE '%8810657712%', none of which worked.

I also did a different query on the...

Tony,

Thanks for the input! I did consider creating a temp table (perhaps @temp or @@temp) to store the 3000+ values, run the bcp queries, then drop the table.

However,...

Steve,

Thanks for the reply. I figured this would be a bit confusing; the "inner" select statement needs to contain all 3000 items. Basically, the criteria needs to be

bcp...

I found a website today that describes variable usage, http://www.sqlis.com/81.aspx .

However, when I have three "columns" of data coming in, index 0, 1, 2, (for the Column1, Column2, Column...