Hi GSquared and Jeff,

Thanks for your kind comments. Jeff, I read both of your links and added a bookmark for each one. They actually contain advice on how...

I frankly don’t understand the intent of your first paragraph. In addition, my issue description says, “We are using SQL Server 2005.” Yes, I am stuck with the...

gary.strange-1058508 (7/14/2010)

---

I can't believe this even made it into sqlservercentral. If this dribble is the quality of articles to come I think I will look for a better provider.

If you...

This is a mistake sorry

I think that replies should avoid attacking the author of an article. That is not productive at all. The author took the initiative to share an experience. ...

Yes. Your boss did the right thing and it was brilliant. But couldn't the three hour query have been the result of an inadequate use-case?

Hi,

I've had two situations where cursors were involved and I'm interested in what you think of them.

The first was as a business analyst at an internet retail company that was...

Jeff,

Thanks again. I'm not using ADO .NET. I'm creating add-ons for an SAP program using their SDK. When I send a SQL statement to get a roecordset,...

Jeffery,

Thanks for your comment. I tried to navigate to the url you provided, but my anti-virus program (Kaspersky) detected three trojans and thus blocked it. Is there another url...

David, yours is a MUCH better answer. Thanks. I had forgotten about the EXCEPT.

Do an left join using all key fields. Any field with a NULL is missing.

Thanks for all the quick responses!

Given them, do I need to make any change to my SQL statement above? If I want to include the time, what...

Good article. I actually didn't have to read it to get it; so I didn't notice the errors. This was due to the use of the Cartesian product...

You can add that the use of the words INNER and OUTER is not necessary.

Here it is:

-- Table Explanations:

-- OITT is the BOM header table

-- ITT1 is the BOM line table

-- OITM is the Item Master table; this is where...