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
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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.