For concatenation u can use FOR XML PATH() to concatenate rows to to a single column

Hi you can use "dynamic pivot" tables.

Here is a sample at T-SQL Pivot Tables in SQL Server - Pivot Table Tutorial with Examples

In pivot tables are actually you build the...

If you eliminate the project_case_id column which causes the rows to differ, you can remove dublicates by grouping other columns as you have done.

Eralper

T-SQL Programmer

Congradulations,

Your exam mark is very nice.

I hope you will go on taking exams 🙂

Eralper

T-SQL Programming

Hi,

First of all you should browse the /Reports folder for viewing reports and executing reports if you want to run reports directly on the reports web application.

And probably the /Reports...

Congratulations and thanks for the information.I believe new exam takers will benefit from your reviews and from your studies.

Eralper

Microsoft Certification Exam Blog

I believe that most companies are on SQL2005 and will not pass to SQL2008 if they really need to do.

But SQL2008 has many enhancements especially for the DB management area...

Hi Thorsten,

70-448 I mean the BI exam for SQL2008 is easy when compared to 2005 version 70-445.

If you have a good knowledge of the basic terms, some real world experience...

Hi all,

I have also taken the 71-448 during its beta period.

I can easily compare the two versions 70-445 and 70-448 that the 445 is far more difficult than the 448...

If you have subscriptions, then you can see them on Schedule ReportServerDB table.

Eralper

T-SQL and SSRS Resources

Hi,

If you mean the Table Valued Parameters, they should be listed below Programmability, Types, User-Defined Table Types.

Eralper

Table Valued Parameters New In SQL Server 2008 T-SQL Improvements

I see that you have worked on virtual machines.

This is good way to keep your original data safe and does not require you database server installations.

For migration, you can...

Hi Frank,

Can you please check the following query which I used the GROUP BY GROUPING SETS

SELECT

ISNULL(SalesOrderID,'AllSalesOrders') SalesOrderID, ProductID, AVG(AVGQTY * 1.0) AVGQTY, AVG(UNIRPRICE) UNIRPRICE

FROM (

SELECT

CAST(SOD.SalesOrderID AS VARCHAR(25)) SalesOrderID,

SOD.ProductID,

orderqty AVGQTY,

UnitPrice...

Hello Frank,

Your query made me feel that you can use the ROLLUP or CUBE t-sql functions.

You know SQL2008 has also introduced the GROUPING SETS.

You will find some samples at Group...

Hi Lynn,

Thanks for your warning 🙂

My main consideration at that function is not the performance in fact.

I just wanted to see if Recursive CTE can manage splitting string values.

In fact...