A
acdsky
Hi all.
I need to change the way data is diplayed after a SQL query. What I am
tying to do is organise data in such a way that MS project will open
the file with minimum mapping. See below what I have got and what I
need:
I have got:
Cust|CallType|Priority|CallID|Asignee|Date ect ect
A | HR | X | 12 | Me | 0/0/2003
A | HR | X | 12 | John | 0/0/2003
B | Deve | Y | 14 | Stan | 0/1/2003
What I need the data to look like is: (the 1-4 is for MS Project
Indents)
1 |A |
2 |HR|
3 |X |
4 |12 | Me | 0/0/2003
4 |12 | John | 0/0/2003
1 |B |
2 |Deve|
3 |Y|
4 |14 | Stan| 0/1/2003
I would appreciate it if anyone could point me in the right direction
with this
Regards
M
I need to change the way data is diplayed after a SQL query. What I am
tying to do is organise data in such a way that MS project will open
the file with minimum mapping. See below what I have got and what I
need:
I have got:
Cust|CallType|Priority|CallID|Asignee|Date ect ect
A | HR | X | 12 | Me | 0/0/2003
A | HR | X | 12 | John | 0/0/2003
B | Deve | Y | 14 | Stan | 0/1/2003
What I need the data to look like is: (the 1-4 is for MS Project
Indents)
1 |A |
2 |HR|
3 |X |
4 |12 | Me | 0/0/2003
4 |12 | John | 0/0/2003
1 |B |
2 |Deve|
3 |Y|
4 |14 | Stan| 0/1/2003
I would appreciate it if anyone could point me in the right direction
with this
Regards
M