Best way to DEBUG is to Response.Write the RegQry string. Go ahead and post the result of this code:

For I = 1 To RecCount

RegQry =...

Do you mean automating an export? You can always copy & paste from the QA results grid or text output. DTS should help you out for automating exports...

...

Coming along just fine. Here are the answers to your questions:

1) Yes, both BOMProduct and ProductDependent have composite PRIMARY KEYS:

--Using my original schema...

ALTER TABLE...

I got the question right, but only because I think I'm getting used to the wording of the QOD. This question is particularly troublesome, as there are 2 correct...

stax68: there's one in Atlanta, too, although I looked at the UK one, and that's impressive, too!:

http://www.ga400nsas.com/photo_gallery/large/image3.asp

Looks to me as if both EXISTS and NOT EXISTS are doing a lot of IO. I would bet that comparing the IO plans against a LEFT JOIN would...

yogiberr: "spaghetti junctions"? no reference to the Atlanta roads system is it? Anyway, it looks like you've had a heck of a crack at a solution, and done fairly...

Thanks for posting those results (I agree about the DBA, BTW I think he removed them because a certain developer said he'd never use them...). ...

NPeeters is right on when he says this will become difficult to manage...Anyway, that said, you could implement a structure like so:

CREATE TABLE Product

(

  ProductID...

Just noticed you said your date field actually stored time portion too. Change to this:

SELECT * FROM MyTable

WHERE DATEADD(D, 0, DATEDIFF(D, 0, MyDateField)) BETWEEN 

DATEADD(D,...

SELECT * FROM MyTable

WHERE MyDateField BETWEEN 

DATEADD(D, -1, DATEDIFF(D, 0, GETDATE()))

AND 

DATEADD(D, 0, DATEDIFF(D, 0, GETDATE()))

mccork, I was unable to get the queries you posted to return an index seek in any of my execution plans, however, I was running against a fully-populated database with...

IMHO, I'd rather hire someone who has more real-life experience and understanding of business than someone who has a ton of book smarts, but has not encountered anything in reality...

try this instead:

ALTER PROCEDURE dbo.DNN_photo_categories_U 

(

  @id int

, @module_id int = NULL

, @category_name varchar(50) = NULL

, @notes varchar(4000) = NULL

, @date datetime = NULL

, @approved...

Best you're going to get is an INDEX SCAN. So, even with an index, it still has to go through the entire index and look for existence. I...