result - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

result

Author

Topic

wtfn00b
Starting Member

6 Posts

Posted - 2010-10-20 : 02:48:05

Hello, how can I get from table A result to table B result

Sachin.Nand

2937 Posts

Posted - 2010-10-20 : 03:15:29

I cannot see the image.Maybe the proxy is blocking it.

Can you explain what you want?

PBUH

wtfn00b
Starting Member

6 Posts

Posted - 2010-10-20 : 03:24:39

A Table

Resp_code___Cnr____Row_num___Cvalue
101962_______1________1_________2
101962_______3________1________2000
101962_______2________1________1950
101962_______5________1________705
101962_______4________1________793

Table B

Resp_code____Row_num____Cnr____Cnr____Cnr____Cnr____Cnr
101962__________1________1______2______3______4______5
_________________________2_____1950___2000___793____705

How with SQL I can get from result A to Table B result ?

wtfn00b
Starting Member

6 Posts

Posted - 2010-10-20 : 03:59:11

Find answer with PIVOT.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources