Mike Eghtebas
asked on
Stored Proc help...
In table Source below, there is a flag field with string values, c or e. Could you please help me with a stored proc to read table Source and put it table Target?
The c-value(e-value) from columns F1 and F2 will show up in the Source table while Name A, B, C each will show only once.
Thank you
The c-value(e-value) from columns F1 and F2 will show up in the Source table while Name A, B, C each will show only once.
Source:
Name F1 F2 flag
A 7 3 c
B 13 4 c
C 0 6 c
A 11 8 e
B 19 9 e
C 4 0 e
Target
Name F1 F2
A 7(11) 3(8)
B 13(19) 4(9)
C -(4) 6(-)
Thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Are you working on SQL Server 2012?
ASKER
Thank you.
Huh? The accepted solution does not and cannot produce the output as stated in the initial request, because it will never combine/merge values from different rows.