将行数据转换为列 [英] Convert ROws data into column

问题描述

我正在关注以下输出....

meterno       LimitValue
1234 1234 1234 1234

但我需要以下格式.

meterno   col1   col2    col3    col4
. >
紧急……
thnx

I am getting following output....

meterno        LimitValue
1234               .23
1234               .24
1234               .13
1234               .17


but I need in following format.

meterno   col1   col2   col3   col4
1234         .23   .24   .13      .17

its urgent......
thnx

推荐答案

看看:
http://www.simple-talk.com /sql/t-sql-programming/switching-rows-and-columns-in-sql/ [ http://www.sqlservercentral.com/Forums/Topic265882-8-1.aspx [ ^ ]
http://forums.asp.net/t/1393540.aspx/1 [ ^ ]
希望他们能帮助您

Have a look to:
http://www.simple-talk.com/sql/t-sql-programming/switching-rows-and-columns-in-sql/[^]
http://www.sqlservercentral.com/Forums/Topic265882-8-1.aspx[^]
http://forums.asp.net/t/1393540.aspx/1[^]
hope they help you

这篇关于将行数据转换为列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！