TSQL: Concatenate Column from Multiple Rows into String

יום שלישי, ינואר 24, 2012

Ok , So I had a problem related to concatenation of a single Column into one ( same ) column when using GROUP BY . The Problem came from a Reporting Services perspective and there might be other solutions ( like coding in VB.NET in the report ) I have found a very nice samples : Option 1: use Northwind declare @CategoryList varchar(1000) set @CategoryList ='' select @CategoryList = @CategoryList + ' , ' +...

Express 2010 RTM Download summary

יום חמישי, אפריל 29, 2010

Express 2010 RTM Download summary Any one who really knows me , knows that my 2nd passion is the Express toolset :) Now, that Visual Studio 2010 has RTM-ed a few days (weeks) a go I have decided to build a small collection of relevant URLs : from http://www.microsoft.com/express/Downloads/ Visual Basic 2010 Express Visual C# 2010 Express Visual C++ 2010 Express Visual Web Developer 2010 Express ( Part of the WebPI Toolkit ) All - Offline Install ISO image file And the SqlServer Express 2008 R2 – with the new 10GB support :) Microsoft SQL Server 2008 R2 RTM - Express with Advanced Services Microsoft SQL Server 2008 R2 RTM...