Hi Andre,

Rebuilding the index for the partitioned table is one of the worst practice.

Create a staging table with a index similar to the partitioned table. Load the data into staging...

Hi Friends,

My dream job is to be a SQL developer. Currently i am into C#/ SQL . Looking for good openings......Salary doesn't matters..i want that designation and work :)..

It can also be done using Pivot Concept...very simple

SELECT Max(date)

FROM (SELECT date

FROM (SELECT date1,

...