- 浏览: 50736 次
- 性别:
- 来自: 南京
文章分类
最新评论
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_MANMONTH1, SUM(RESOURCE_ASSIGN.MANMONTH_02) AS SUM_MANMONTH2, SUM(RESOURCE_ASSIGN.MANMONTH_03) AS SUM_MANMONTH3, SUM(RESOURCE_ASSIGN.MANMONTH_04) AS SUM_MANMONTH4, SUM(RESOURCE_ASSIGN.MANMONTH_05) AS SUM_MANMONTH5, SUM(RESOURCE_ASSIGN.MANMONTH_06) AS SUM_MANMONTH6, SUM(RESOURCE_ASSIGN.MANMONTH_07) AS SUM_MANMONTH7, SUM(RESOURCE_ASSIGN.MANMONTH_08) AS SUM_MANMONTH8, SUM(RESOURCE_ASSIGN.MANMONTH_09) AS SUM_MANMONTH9, SUM(RESOURCE_ASSIGN.MANMONTH_10) AS SUM_MANMONTH10, SUM(RESOURCE_ASSIGN.MANMONTH_11) AS SUM_MANMONTH11, SUM(RESOURCE_ASSIGN.MANMONTH_12) AS SUM_MANMONTH12, EFFORT_ESTIMATION.EFFORT_ESTIMATION_ID, EFFORT_ESTIMATION.MONTH_1, EFFORT_ESTIMATION.MONTH_2, EFFORT_ESTIMATION.MONTH_3, EFFORT_ESTIMATION.MONTH_4, EFFORT_ESTIMATION.MONTH_5, EFFORT_ESTIMATION.MONTH_6, EFFORT_ESTIMATION.MONTH_7, EFFORT_ESTIMATION.MONTH_8, EFFORT_ESTIMATION.MONTH_9, EFFORT_ESTIMATION.MONTH_10, EFFORT_ESTIMATION.MONTH_11, EFFORT_ESTIMATION.MONTH_12 FROM RESOURCE_ASSIGN INNER JOIN EFFORT_ESTIMATION ON RESOURCE_ASSIGN.FK_EFFORT_ESTIMATION_ID = EFFORT_ESTIMATION.EFFORT_ESTIMATION_ID INNER JOIN BUDGET ON EFFORT_ESTIMATION.FK_BUDGET_ID = BUDGET.BUDGET_ID WHERE (BUDGET.IS_IN_PROCESS = 1) GROUP BY EFFORT_ESTIMATION.EFFORT_ESTIMATION_ID, EFFORT_ESTIMATION.MONTH_1, EFFORT_ESTIMATION.MONTH_2, EFFORT_ESTIMATION.MONTH_3, EFFORT_ESTIMATION.MONTH_4, EFFORT_ESTIMATION.MONTH_5, EFFORT_ESTIMATION.MONTH_6, EFFORT_ESTIMATION.MONTH_7, EFFORT_ESTIMATION.MONTH_8, EFFORT_ESTIMATION.MONTH_9, EFFORT_ESTIMATION.MONTH_10, EFFORT_ESTIMATION.MONTH_11, EFFORT_ESTIMATION.MONTH_12 )AAAAA where (SUM_MANMONTH1 = MONTH_1 and SUM_MANMONTH2 = MONTH_2 and SUM_MANMONTH3 = MONTH_3 and SUM_MANMONTH4 = MONTH_4 and SUM_MANMONTH5 = MONTH_5 and SUM_MANMONTH6 = MONTH_6 and SUM_MANMONTH7 = MONTH_7 and SUM_MANMONTH8 = MONTH_8 and SUM_MANMONTH9 = MONTH_9 and SUM_MANMONTH10 = MONTH_10 and SUM_MANMONTH11 = MONTH_11 and SUM_MANMONTH12 = MONTH_12) )
Preparation&Draft:
1.
SELECT SUM(RESOURCE_ASSIGN.MANMONTH_01) AS SUM_MANMONTH1, SUM(RESOURCE_ASSIGN.MANMONTH_02) AS SUM_MANMONTH2, SUM(RESOURCE_ASSIGN.MANMONTH_03) AS SUM_MANMONTH3, SUM(RESOURCE_ASSIGN.MANMONTH_04) AS SUM_MANMONTH4, SUM(RESOURCE_ASSIGN.MANMONTH_05) AS SUM_MANMONTH5, SUM(RESOURCE_ASSIGN.MANMONTH_06) AS SUM_MANMONTH6, SUM(RESOURCE_ASSIGN.MANMONTH_07) AS SUM_MANMONTH7, SUM(RESOURCE_ASSIGN.MANMONTH_08) AS SUM_MANMONTH8, SUM(RESOURCE_ASSIGN.MANMONTH_09) AS SUM_MANMONTH10, SUM(RESOURCE_ASSIGN.MANMONTH_10) AS SUM_MANMONTH10, SUM(RESOURCE_ASSIGN.MANMONTH_11) AS SUM_MANMONTH11, SUM(RESOURCE_ASSIGN.MANMONTH_12) AS SUM_MANMONTH12, EFFORT_ESTIMATION.EFFORT_ESTIMATION_ID, EFFORT_ESTIMATION.MONTH_1, EFFORT_ESTIMATION.MONTH_2, EFFORT_ESTIMATION.MONTH_3, EFFORT_ESTIMATION.MONTH_4, EFFORT_ESTIMATION.MONTH_5, EFFORT_ESTIMATION.MONTH_6, EFFORT_ESTIMATION.MONTH_7, EFFORT_ESTIMATION.MONTH_8, EFFORT_ESTIMATION.MONTH_9, EFFORT_ESTIMATION.MONTH_10, EFFORT_ESTIMATION.MONTH_11, EFFORT_ESTIMATION.MONTH_12 FROM RESOURCE_ASSIGN INNER JOIN EFFORT_ESTIMATION ON RESOURCE_ASSIGN.FK_EFFORT_ESTIMATION_ID = EFFORT_ESTIMATION.EFFORT_ESTIMATION_ID INNER JOIN BUDGET ON EFFORT_ESTIMATION.FK_BUDGET_ID = BUDGET.BUDGET_ID WHERE (BUDGET.IS_IN_PROCESS = 1) GROUP BY EFFORT_ESTIMATION.EFFORT_ESTIMATION_ID, EFFORT_ESTIMATION.MONTH_1, EFFORT_ESTIMATION.MONTH_2, EFFORT_ESTIMATION.MONTH_3, EFFORT_ESTIMATION.MONTH_4, EFFORT_ESTIMATION.MONTH_5, EFFORT_ESTIMATION.MONTH_6, EFFORT_ESTIMATION.MONTH_7, EFFORT_ESTIMATION.MONTH_8, EFFORT_ESTIMATION.MONTH_9, EFFORT_ESTIMATION.MONTH_10, EFFORT_ESTIMATION.MONTH_11, EFFORT_ESTIMATION.MONTH_12
2.
SELECT COUNT(*) AS Expr1 FROM (SELECT EFFORT_ESTIMATION.* FROM EFFORT_ESTIMATION WHERE (FK_BUDGET_ID IN (SELECT budget_id FROM budget WHERE is_in_process = 1))) EffortEstimatonbak----1774 SELECT COUNT(*) AS Expr1 FROM (SELECT * FROM RESOURCE_ASSIGN WHERE (FK_EFFORT_ESTIMATION_ID IN (SELECT EFFORT_ESTIMATION_ID FROM EFFORT_ESTIMATION WHERE (FK_BUDGET_ID IN (SELECT budget_id FROM budget WHERE is_in_process = 1))))) r_aBAK---------1014 SELECT COUNT(*) AS Expr1 FROM (SELECT SUM(RESOURCE_ASSIGN.MANMONTH_01) AS SUM_MANMONTH1, EFFORT_ESTIMATION.EFFORT_ESTIMATION_ID FROM RESOURCE_ASSIGN INNER JOIN EFFORT_ESTIMATION ON RESOURCE_ASSIGN.FK_EFFORT_ESTIMATION_ID = EFFORT_ESTIMATION.EFFORT_ESTIMATION_ID INNER JOIN BUDGET ON EFFORT_ESTIMATION.FK_BUDGET_ID = BUDGET.BUDGET_ID WHERE (BUDGET.IS_IN_PROCESS = 1) GROUP BY EFFORT_ESTIMATION.EFFORT_ESTIMATION_ID) aaaa----441
----------------------------
SELECT RESOURCE_ASSIGN_ID, FK_MEMBERRESOURCE_ID, FK_EFFORT_ESTIMATION_ID, MANMONTH_10, MANMONTH_11, MANMONTH_12,
MANMONTH_01, MANMONTH_02, MANMONTH_03, MANMONTH_04, MANMONTH_05, MANMONTH_06, MANMONTH_07, MANMONTH_08,
MANMONTH_09
FROM RESOURCE_ASSIGN
WHERE (FK_EFFORT_ESTIMATION_ID IN
(SELECT EFFORT_ESTIMATION_ID
FROM EFFORT_ESTIMATION
WHERE (FK_BUDGET_ID = 605) AND (FK_FISCALYEAR_ID = 4) AND (FK_DIVISION_ID = 8)))
发表评论
-
PRT maintainence
2015-09-23 20:33 0jjjeeee -
Migration Prepration & Notice
2011-07-28 10:25 0Problem1: some ee=0 should d ... -
BUDGET & FY_BUDGET_W 一起处理
2011-07-12 13:54 711Version 1 declare @budgetI ... -
BUDGET,FY_BUDGET_W
2011-07-08 13:48 0Version1: SELECT ee.*, BUDGE ... -
FY_Budget_W
2011-07-07 15:46 627version1: declare @budgetIdmax ... -
Align Traffic light //Batch update EffortEstimation set IS_ALIGNED value =1 or 0
2011-04-14 15:04 0string effsAligned = (p ... -
你看错了吧?!
2011-04-13 10:12 685SELECT BUDGET.BUDGET_ID, BUDGET ... -
DataMigration script
2011-03-24 11:14 9741. not keep the budget plan his ... -
temp store
2011-03-18 15:14 0SELECT RESOURCEASSIGNMENT.RESOU ... -
temporay note
2011-03-04 16:04 752declare @projectidmax int,@curp ... -
Migrate budget table,MemberResource table
2011-03-04 15:57 695Add two column set default val ... -
Delete Script
2011-03-04 15:16 723declare @projectidmax int,@curp ... -
Delete Top n-1 from a groud of records of a table
2011-03-04 14:35 709Test successfully! decla ... -
Import data from ResourceAssignment into Resource_Assign
2011-03-04 14:29 930insert into RESOURCE_ASSIGN( MA ...
相关推荐
xiaoyo_release_2020_11_14_13-20_v2.7.7_201104_jiagu_signed_aligned.apk
app_official_release_7.0.5.2_2023010610_2023-01-09_10-23-35_legu_aligned_signed.apk
手机版可道云APP,可NAS,可在windows里安装好可道云服务器后便 可以安装在手机上面的可道云客户端,实现远程管理文件及观看视频
《戏曲之家v1.0_2019-08-05_09-08-36_legu_aligned_signed.zip》是一个压缩包文件,其中包含了一个名为“戏曲之家v1.0_2019-08-05_09-08-36_legu_aligned_signed.apk”的应用程序。这个应用显然是针对中国传统文化...
pre-UAL syntax does not specify the "s" (flag update) in the opcodes for arithmetic operations involving the low set of registers (r0-r7). For example: pre-UAL Syntax | UAL Syntax ;Note -----------...
lunar_codemao_hi_4.3.3_release_aligned_signed_codemao.apk
标题“CE170_Center_Aligned_PWM_030110_pwm_centeraligned_Center_hbridge”揭示了我们关注的主题是关于中心对齐的PWM(Center Aligned PWM)技术,这在微控制器sdPIC33系列的应用中特别提及。sdPIC33系列是...
应用介绍 用自己的照片就能预览几百种女生发型了!无需复杂的操作,只要拖一拖,拽一拽,ok,轻松搞定...1.所见即所得,轻松预览各种发型。 1.拖一拖,拽一拽,操作简单方便。 2.发型丰富,多达几百种。 3.永久免费。
koolearn_daxue_aligned_signed_guanfang(29).apk
x_radius = 1, y_radius = 1, t_radius = 4, xy_neighbor=8, xt_neighbor=8, yt_neighbor=8, xy_bins = 8, xt_bins = 12, yt_bins = 12, bins=8) ep: 提取特征的图像序列 uniform_dict: 用于减小LBP-...
app_official_release_7.1.2.2_2024040116_2024-04-01_17-03-28_legu_aligned_signed.apk
aweme_resource_test_v22.0.0_ad10c88-with-plugins_channel_7zip_aligned-signed (2).apk.1
《深度学习视角下的对齐人脸数据集:aligned_faces.rar详解》 在当今的计算机视觉领域,深度学习技术已经成为处理图像识别、人脸识别等任务的核心手段。一个高质量的数据集对于训练高效、精准的深度学习模型至关...
dkplat_v15.5_23_aligned_signed-138746-o_1f46v0l9fgf6f0o4fb11jaeutr-uid-1130970.apk
LSIP200232921 (DFCT) MegaCLI displays version for PD in unclear format and the data is not aligned correctly LSIP200232954 (DFCT) Need to Support all the MFC default values in the command AdpSettings...
\[ R' \approx \frac{1}{k_1 k_2 m_1 m_2 n_1 R_1 C_1} \] 当特定参数取值满足一定的条件时,可以进一步简化设计公式。例如,当\( k_1 = k_2 = k, m_1 = m_2 = m, n_1 = 1 \)时,输出电压与输入电压二阶导数的关系...
对于这个问题,初始基本解可以是 \(x_1 = 0, x_2 = 0, s_1 = 14, s_2 = 50, s_3 = -18\)。但因为 \(s_3 ),所以这个解是不可行的,需要重新选择初始解。 ##### 3. 构建基本解 对于加入松弛变量后的一共有 \(R=5\) ...
for key, value in dict1.items(): print(f"{key}: {value}") ``` 这将分别打印出字典dict1的每个键值对。 2. 搜索和替换文本: 在字符串中搜索和替换文本,我们可以使用`str.replace()`方法。如果需要更复杂的...
* packets in and out, so there is place for a packet */ struct snull_priv { struct net_device_stats stats; int status; struct snull_packet *ppool; struct snull_packet *rx_queue; /* List of ...
./soapdenovo all -s config_file config_file设置如下: # maximal read length max_rd_len=150 # average insert size avg_ins=350 # if sequence needs to be reversed reverse_seq=0 # in which part(s) the ...