We blogged about SQLBits community day previously and now sessions are available online for your selection, vote now! As referred by Tony Rogerson : You will need to register on the site and then select the 10 sessions ( http://www.sqlbits.com/information/PublicSessions.aspx ) you would most like to see. We will use this voting to help decide ...

Jeff Smith in his weblog showed how to generate Crosstab reports using a stored procedure. I had a requirement to generate crosstab reports with more than one pivot column. So I used the same approach he used and modified his procedure as shown below CREATE procedure CrossTab ( @select varchar(2000), @PivotCol varchar(100), @Summaries ...

Event: Microsoft ASP.NET Connections, Visual Studio Connections, SharePoint Connections, Mobile Connections, Architect Connections, and SQL Server Magazine Connections When: November 5 - 8, Las Vegas, NV Dive hard into current and future releases from Microsoft for the developer, DBA, and architect at DevConnections. Come learn about Visual Studio ...