I agree.

Logically you're defining the join criteria in the ON clause. Based on that criteria, looking at the code, your left join worked perfectly. If you wish to filter...

Physically, yes. The operate side by side with no issues. Licensing, you need a license for each, you have to trade one license in, or you have to get the...

I've never heard of anything that'll help. You'll either have to modify the procedure to disable the PRINT statements or you have to modify the code so that it can...

Nah, we're still aspiring to reach sewer rat. I'm thinking this will get us from cockroach to water...

One way:

SELECT t.A1

FROMtest t

JOIN test t2

ON t.A1 = t2.A1

WHERE t.A2 = 1

AND t2.A2 = 4

That will make...

Please don't cross-post. Especially don't post things in the 2008 forums that has no relation to 2008.

Oh yeah, do that. The Static Code Analysis tool is a great way to review TSQL. It replaces a lot of the functionality that they dropped from the Best Practices...

Not knowing much else, I can make too guess. First, the indexes need to be rebuilt or your statistics are out of date. This can lead the optimizer to make...

Indexes can be, but aren't always, a performance problem when performing ETL. Best answer to that question is for you to test your load both ways, running with the indexes...

Thanks for confirming Steve. I'd done several searches and hadn't come up with anything.

That is truly sad news.

I thought he was fairly young.

Really? Hmm. That actually used to be a specialty of theirs because they were bringing so many people over from ERWin. I haven't upgraded an ERWin model myself since 2002....

Put me down for Embarcadero ERStudio too. Great tool.

Microsoft will allow you to transfer your Developer license to a Database license. I know because I did it. You just have to remove the developer edition before installing DBPro....

Personall, I'd start here.