I have a table sitting in SQL Server. I have a need to "flatten out" a table. Here is my basic table
Date Person Prize1 Prize2 Prize3
1/1/2009 11:01:02 Bill Item1 Item2 Item3
1/1/2009 11:05:23 Bill Item4 NULL NULL
I need to manipulate the data so Bill is just one record. A 4th field would need to be added to the output. I dont care about the timestamp. The new record would just have a value of 1/1/2009. Would need sql code to do this.
Result set would be:
Date Person Prize1 Prize2 Prize3 Prize4
1/1/2009 Bill Item1 Item2 Item3 Item4
MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
SQL Server Integration Services can read XML files, that’s known by every BI developer. (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.)
But how far can you go? When does the XML Source component become …
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed