RETAILREALM
asked on
Sql row to column
I have two columns as shown below
ColA ColB
Cash 100
Check 200
Card 300
I want result as
Cash Check Card
100 200 300
Here colA has run time values so i can't make it hard code
ColA ColB
Cash 100
Check 200
Card 300
I want result as
Cash Check Card
100 200 300
Here colA has run time values so i can't make it hard code
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks guys for your help
Open in new window