本文介绍了将列数据转换为行的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
大家好,
我有一个要求.
我需要将列数据转换为sql server 2000中的行.能帮帮我吗?
数据就是这样
SCRIPT ID IQV ACTIVITY ID QUESTION ANSWER 5 900044 9 - sites in country A. 1 - 9 5 900044 10b - Database A. Oracle 5 900044 13 - Virtualised servers A. None virtualised 5 900055 10 - Employees (users) B.10 – 100 5 900055 Do Not Contact No
我想要这样:
SCRIPT ID IQV ACTIVITY ID QUESTION ANSWER QUESTION ANSWER QUESTION ANSWER 5 900044 9 - sites in country A. 1 - 9 10b - Database A. Oracle 13 - Virtualised servers A. None virtualised 5 900055 10 - Employees (users) B.10 – 100 Do Not Contact No
请帮助我.
提前谢谢!
问候
Govardhan
解决方案
感谢harlinn.
解决了.
Hi All,
I have one requirement.
I need to convert the columns data to rows in sql server 2000. Can you help me out.
Data is like this
SCRIPT ID IQV ACTIVITY ID QUESTION ANSWER 5 900044 9 - sites in country A. 1 - 9 5 900044 10b - Database A. Oracle 5 900044 13 - Virtualised servers A. None virtualised 5 900055 10 - Employees (users) B.10 – 100 5 900055 Do Not Contact No
I want to it in this way:
SCRIPT ID IQV ACTIVITY ID QUESTION ANSWER QUESTION ANSWER QUESTION ANSWER 5 900044 9 - sites in country A. 1 - 9 10b - Database A. Oracle 13 - Virtualised servers A. None virtualised 5 900055 10 - Employees (users) B.10 – 100 Do Not Contact No
Please help me in this.
Thanks in advance!
Regards
Govardhan
解决方案
这篇关于将列数据转换为行的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!