SQL coding question.
Consider the following table: Itin
ID Restraunt Date Position
--- -------------- ------ ----------
1 Mikes 2/1/14 Waiter-1
2 Mikes 2/1/14 Waiter-2
3 Mikes 2/1/14 Waiter-3
4 John 2/1/14 FrontDesk
5 John 2/1/14 Bartender
6 John 2/2/14 Waiter-1
7 John 2/2/14 Waiter-3
15 Mikes 2/2/14 Waiter-3
8 Mikes 2/2/14 Tables
9 Mikes 2/3/14 Waiter-3
10 Mikes 2/3/14 FrontDesk
11 Mikes 2/4/14 Bartender
12 Mikes 2/4/14 Waiter-1
13 Mikes 2/4/14 Waiter-3
What I want to do, is show the above in a grid of at least three or four columns.
Restraunt Date Positions
-------------- ------ ---------
John 2/1/14 Bartender Frontdesk
John 2/2/14 Waiter-1 Waiter-3
Mike 2/1/14 Waiter-1 Waiter-2 Waiter-3
Mike 2/2/14 Waiter-3 FronDesk
Is there anyway to remotely do this via a SQL query?
Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!
Sometimes MS breaks things just for fun...
In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset.
Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters.
MySQLTuner is a script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability. The current configuration variables and status data is retrieved and presented in a brief forma…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other.
As you build tables in Microsoft Ac…