Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements
1 Contribution
Ranked #107.73K
Discussions / Questions x 1
~95 People Reached
Favorite Forums
Databases x 1
Favorite Tags
microsoft:sql-server x 1
database-design x 1

1 Posted Topic

Member Avatar for usenthil75
One column value to multiple rows
Share on Facebook Share on X Share on LinkedIn

I have the problem of splitting the the table into following way. Pl help me in doing it Actual table Product Id ProductQty CompCapacity 1 8000 5000 2 10000 5000 4000 4000 Resultant table Product Id ProductQty CompCapacity 2 5000 5000 2 5000 5000 1 4000 4000 1 4000 4000

Databases database-design microsoft:sql-server
Member Avatar for tesuji
0
2
95

The End.