日期:2014-05-16 浏览次数:20898 次
----------------------------------------------------------------
-- Author :fredrickhu(小F,向高手学习)
-- Date :2014-03-27 10:10:43
-- Verstion:
-- Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
-- Jul 9 2008 14:43:34
-- Copyright (c) 1988-2008 Microsoft Corporation
-- Enterprise Edition on Windows NT 6.1 <X86> (Build 7601: Service Pack 1)
--
----------------------------------------------------------------
--> 测试数据:[ProjectAndPosition]
if object_id('[ProjectAndPosition]') is not null drop table [ProjectAndPosition]
go
create table [ProjectAndPosition]([wprojectid] varchar(23),[positionName] varchar(12),[num] int)
insert [ProjectAndPosition]
select 'NoProject','规划部部长',1 union all
select 'a