| View previous topic :: View next topic |
| Author |
Message |
trvln_nole
Beginner
Joined: 31 Jul 2006
Posts: 2
Topics: 1
|
 Posted: Mon Jul 31, 2006 12:06 pm Post subject: Looking for SQL solution to odd query |
 |
|
I am trying to combine mutilple rows (no guarentee on how many rows) into a single record result.
My table is:
| Code: |
Acct Date Action
0001 7/31/06 Sign-In
0001 7/31/06 Work
0001 7/31/06 Lunch
0001 7/31/06 Siesta
0001 7/31/06 Sign-Out
0002 7/31/06 Sign-In
0002 7/31/06 Work
0002 7/31/06 Out Sick
|
Result should be:
| Code: |
0001 7/31/06 Sign-In Work Lunch Siesta Sign-Out
0002 7/31/06 Sign-In Work Out Sick
|
Any help would be appreciated |
|
| Back to top |
|
 |
coolman
Intermediate
Joined: 03 Jan 2003
Posts: 283
Topics: 27
Location: US
|
| Posted: Mon Jul 31, 2006 1:23 pm Post subject: |
|
|
What's the max. no of rows expected on an acct per day?
________
Mercury Topaz history
Last edited by coolman on Sat Feb 05, 2011 1:45 am; edited 1 time in total |
|
| Back to top |
|
|
trvln_nole
Beginner
Joined: 31 Jul 2006
Posts: 2
Topics: 1
|
| Posted: Tue Aug 01, 2006 3:26 pm Post subject: |
|
|
Coolman,
I was expecting at most 7 per day, out of 13 possible actions.
It needs to be a stand alone Query I can run under SPUFI or some other SQL tool.
While I did come up with an answer, I would like a second opinion. |
|
| Back to top |
|
|
coolman
Intermediate
Joined: 03 Jan 2003
Posts: 283
Topics: 27
Location: US
|
| Posted: Wed Aug 02, 2006 3:53 pm Post subject: |
|
|
| Quote: |
It needs to be a stand alone Query I can run under SPUFI or some other SQL tool.
While I did come up with an answer, I would like a second opinion.
|
Was your answer a query or did you use a stored proc to solve this?
________
full melt bubble hash
Last edited by coolman on Sat Feb 05, 2011 1:46 am; edited 1 time in total |
|
| Back to top |
|
|
js01
Beginner
Joined: 13 Oct 2005
Posts: 84
Topics: 32
Location: INDIA
|
| Posted: Wed Aug 23, 2006 6:30 pm Post subject: |
|
|
Hi,
I have same requirement ,can any one post me the query please.
thank you |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
