That's what I was wondering. Thank you, Gus. You have saved me some head-banging time.

When executing your query in SSMS, go to Query -> Include Actual Execution Plan. Alternately, if you don't want to run the query, you can use Query -> Display Actual...

Books Online has all the details on how to use the transformation tasks that I told you about. If you want to use SSIS, refer to that and the Microsoft...

Drew, how does that prevent NULL from overriding your 0?

If there's no auditing, then the only possible option is to look at Active Directory for those logins that are domain logins. If they're all SQL logins, there is nothing...

Stefan Krzywicki (5/17/2012)

GSquared (5/17/2012)

Stefan Krzywicki (5/17/2012)

Steve Jones - SSC Editor (5/17/2012)

Thanks to new data mining abilities I think I read that they have the ability, to 75% or 90% or...

If you want an answer, you should post the name of the solution you found and ask for reviews.

There are several third party tools and not everyone knows them all...

Unless you've been auditing the logins, there's no good way to tell. Nothing in the system, that I am aware of, can give you this information.

Sorry.

EDIT: On the other hand,...

John,

Gail is asking you to save the execution plan as a .sqlplan and attach it to your post. Do you know how to do this?

You are welcome.

Just an FYI, though. You posted your question in the wrong group. Try General under 2008 or Business Intelligence under 2005 (which covers both 2k5 & 2k8).

Hey, Steve, can you change the birth year in my profile to read 1776, please?

😀

Revenant (5/17/2012)

Stefan Krzywicki (5/17/2012)

Steve Jones - SSC Editor (5/17/2012)

Thanks to new data mining abilities I think I read that they have the ability, to 75% or 90% or something like...

In SSIS, you can use a MERGE JOIN transformation task, I believe. Or you can use Slowly Changing Dimensions. It depends on your business rules, etc.

Check them out in...

Here's another method:

CREATE TABLE dbo.BrandieTemp (MyID INT NOT NULL, TestCol1 VARCHAR(35),

TestCol2 VARCHAR(10));

GO

INSERT INTO dbo.BrandieTemp (MyID, TestCol1, TestCol2)

VALUES (1,'Mickey','Mouse'), (2,'Donald','Duck'), (3,'Goofy','who?');

SELECT MyID, TestCol1, TestCol2

INTO #MyTemp

FROM dbo.BrandieTemp;

ALTER TABLE dbo.BrandieTemp

...

Eugene Elutin (5/17/2012)

Could...