sqlserver2000字段行转列

----建表语句

IF object_id('
[tb]
') IS NOT NULL DROP TABLE [
tb
] CREATE TABLE [
tb
]([
sIDNo
] int,
[
sAccount
] int) INSERT [
tb
]
                  SELECT 1001, 15451551
UNION ALL
SELECT 1001, 13151345
UNION ALL
SELECT 1001, 15484565
UNION ALL
SELECT 1002, 15487963
UNION ALL
SELECT 1002, 21544454
UNION ALL
SELECT 1003, 95235646
UNION ALL
SELECT 1003, 12321512

SELECT sIDNo, dbo.f_str(sIDNo) AS sAccount
FROM tb t
GROUP BY sIDNo