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
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes. We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel.
Part 1 of this series discussed basic error handling code using VBA.