34,590
社区成员
发帖
与我相关
我的任务
分享
declare @a table (citem_class varchar(4),citem_name varchar(10),ctable varchar(11))
insert into @a
select '"99"','"成本对象"','"fitemss99"' union all
select '"00"','"在建工程"','"fitemss00"'
declare @b table (citemcode varchar(4),citemname varchar(16))
insert into @b
select '"01"','"磷酸二钠片"' union all
select '"02"','"盐酸钠片"' union all
select '"03"','"复方丹参注射液"'
select * from @a CROSS JOIN @b ORDER BY 1 DESC
/*
citem_class citem_name ctable citemcode citemname
----------- ---------- ----------- --------- ----------------
"99" "成本对象" "fitemss99" "01" "磷酸二钠片"
"99" "成本对象" "fitemss99" "02" "盐酸钠片"
"99" "成本对象" "fitemss99" "03" "复方丹参注射液"
"00" "在建工程" "fitemss00" "01" "磷酸二钠片"
"00" "在建工程" "fitemss00" "02" "盐酸钠片"
"00" "在建工程" "fitemss00" "03" "复方丹参注射液"
*/