SQL Server
文章平均质量分 73
WonderfulGrass
这个作者很懒,什么都没留下…
展开
-
BUDGET & FY_BUDGET_W 一起处理
Version 1declare @budgetIdmax int,@curBudgetId int,@FYbudgetStatus varchar(20); select @budgetIdmax=max(budget_id) from budget; set @curBudgetId=1...原创 2011-07-12 13:54:13 · 113 阅读 · 0 评论 -
FY_Budget_W
version1:declare @budgetIdmax int,@curBudgetId int; select @budgetIdmax=max(budget_id) from budget;set @curBudgetId=1;while @curBudgetId<=@budgetIdmax...原创 2011-07-07 15:46:50 · 93 阅读 · 0 评论 -
temporay note
declare @projectidmax int,@curprojectid int;select @projectidmax=max(fk_project_id) from budget;while @curprojectid<@projectidmax begin declare @num int;select @num=count(*) from budget where...原创 2011-03-04 16:04:01 · 89 阅读 · 0 评论 -
Migrate budget table,MemberResource table
Add two columnset default value for table field propertyset current value ALTER TABLE dbo.BUDGET ADD IS_IN_PROCESS bit NULL, BUDGET_PLAN_STATUS nvarchar(50) NULLGOALTER TABLE dbo.BUDGE...原创 2011-03-04 15:57:39 · 103 阅读 · 0 评论 -
Delete Script
declare @projectidmax int,@curprojectid int;select @projectidmax=max(fk_project_id) from budget;while @curprojectid<@projectidmax begin declare @budgetidmax int;select @budgetidmax=ma...原创 2011-03-04 15:16:01 · 76 阅读 · 0 评论 -
Delete Top n-1 from a groud of records of a table
Test successfully! declare @num int;select @num=count(*) from budget where fk_project_id=62;declare @topstr nVARCHAR(256);set @topstr='select top'+str(@num) +' * from budget'; execu...原创 2011-03-04 14:35:01 · 102 阅读 · 0 评论 -
Import data from ResourceAssignment into Resource_Assign
insert into RESOURCE_ASSIGN( MANMONTH_10, MANMONTH_11, MANMONTH_12, MANMONTH_01, MANMONTH_02, MANMONTH_03, MANMONTH_04, MANMONTH_05, MANMONTH_06, MANMONTH_07, MANMONTH_08, MANM...原创 2011-03-04 14:29:05 · 61 阅读 · 0 评论 -
Set IS_ALIGNED='1' for EEs of all budgets in process&Delete sw's RS
Final sql script version : update Effort_estimation set is_aligned='1' where EFFORT_ESTIMATION_ID in (select EFFORT_ESTIMATION_ID from(SELECT SUM(RESOURCE_ASSIGN.MANMONTH_01) AS SUM_MANMO...原创 2011-04-15 13:31:58 · 92 阅读 · 0 评论 -
DataMigration script
1. not keep the budget plan history, only keep the current budget plan data and all status will be set "DRAFT" and have to start a new lifecycle in new process control; 2. resource assigned to pr...原创 2011-03-24 11:14:10 · 64 阅读 · 0 评论