Lovely! Tasks get easier everyday.

I have never use PowerShell though. Can you please tell me the resources that I need to get started on PowerShell. Thanks

Nice one. Beautiful!

Ninja's_RGR'us (10/26/2011)

---

Thanks for the legwork Chris.

@StaintGr8, please notice how you can run the inner queries simply by highlighting then and hitting F5 (excluding the correlation... can't do that with the...

Hello!

I've got the answer from another blog. Here it goes!

;WITH CTEPledgeAmount AS(

SELECT LastName , SUM(PledgeAmount)PledgeTotalPerIndividual

FROM dbo.Members AS m

LEFT JOIN dbo.Pledges AS p ON m.MemberIdentityID = p.MemberIdentityID

GROUP BY LastName),...

Ninja's_RGR'us (10/26/2011)

---

The way I do this without preaggregating everything is with an outer apply.

Works reasonably fast here so I didn't bother trying to find faster way to access the data,...

Your advice, I strongly believe is the way forward. But the business rules is to avoid NULL as much as possible hence multiple tables. At the same time they want...

IF OBJECT_ID('dbo.Members') IS NOT NULL

BEGIN

DROP TABLE dbo.Members;

END;

CREATE TABLE dbo.Members(

--MemberID INT NOT NULL

MemberIdentityID INT NOT NULL IDENTITY(1,1)

, LastName ...

Make sure your table is within the double quote, e.g: "HumanResources.Employee"

Beautiful!

It works. Olga, you rock!

I so much enjoyed the lecture. I mean this is simply beautiful. I cannot wait to have it up and running in my environment.

I ran the query [sp_SourceTargetMapping] and then...

Lovely!

Done and dusted!

Thanks a lot.

No! I will do that right now. That mean that I can highlight any schema and table name in a database and hit the keys.

Thanks for the help.

Matt Wright (9/22/2011)

---

As others have mentioned, I have CTRL+0 set up as "SELECT * FROM", Yes, I know it's bad using SELECT * but picking 50 is arbitrary and I...

So, how to you go about that please?