如何把这列的内容分成两列内容?

[love16]

我有一个表,其中一列的内容是这样子的:
rqsj
2004-05-01 15:32:52.077
2004-05-01 15:36:43.950
2004-05-01 15:50:51.437
2004-05-01 16:32:16.810
2004-05-01 17:41:59.390
2004-05-01 18:48:41.950
2004-05-01 19:14:19.890
2004-05-01 19:16:31.357
我现在想要分成两列内容:
rq sj
2004-05-01 15:32:52.077
2004-05-01 15:36:43.950
2004-05-01 15:50:51.437
2004-05-01 16:32:16.810
2004-05-01 17:41:59.390
2004-05-01 18:48:41.950
2004-05-01 19:14:19.890
2004-05-01 19:16:31.357
我该怎么写SQL语句.

[zjcxc]

select rq=convert(char(10),rqsj,120),sj=convert(varchar,rqsj,108)
from 表

[love16]

谢谢建哥,以后多多帮忙.