Thursday, February 17, 2011

PowerPivot tutorial videos

PowerPivot Video Tutorial

Set 1
Set 2
If you are interested in Business Intelligence video tutorials, I would recommend you to visit Microsoft’s Channel 9, plenty more of the good stuff there.

Converting multiple rows into a single comma separated row

Create Table #Names (name varchar(10))

Insert Into #Names(name) values ('varun')
Insert Into #Names(name) values ('vinod')
Insert Into #Names(name) values ('manognya')
Insert Into #Names(name) values ('aradhana')
Insert Into #Names(name) values ('manoj')


SELECT STUFF((SELECT   ', '+  name as [text()] from #Names  FOR  XML PATH('')),1,2,'')

DROP Table #Names

Microsoft Dynamics CRM 2011 Released for On-Premises and Partner-Hosted Deployments

Microsoft Corp. (Nasdaq “MSFT”) today announced that Microsoft Dynamics CRM 2011 for on-premises and partner-hosted deployments has been completed and released for customer download. This release complements the latest version of Microsoft Dynamics CRM Online, which delivers Microsoft Dynamics CRM 2011 as an on-demand service from Microsoft’s datacenters and was launched into 40 markets and 41 languages in January. With a single multitenant code base across cloud and on-premises deployment models, Microsoft Dynamics CRM 2011 delivers the Power of Productivity to sales, service and marketing organizations worldwide.

Microsoft Dynamics CRM 2011 is now globally available and existing customers with active Microsoft Software Assurance agreements can access the new version immediately via the Microsoft Download Center. ( ).

Read the rest of the press release here:

Congratulations to the CRM program team from the 12,000 members of the Microsoft Dynamics CRM. LinkedIn community.