当前位置: 代码迷 >> Sql Server >> sql集锦,很棘手
  详细解决方案

sql集锦,很棘手

热度:38   发布时间:2016-04-24 23:51:18.0
sql汇总,很棘手
本帖最后由 pctonc 于 2012-12-30 15:47:47 编辑



 编号      身份(1:民警,2:工人)   (1:申请入党,2:入积极分子)    团员或党员(1:团员,2:党员)         调入(1:调入)       调出 (1:调出)      原有人员                 创建时间
user_id       use_identity   user_Organize    usermemberorparty            usercallin         usercallout       user_ownedemployees       create_time
  1              1 2  1                         1                 0                      1               2012-1-10 13:11:52.577
  2              1 2  1                         0                 1                      1               2012-2-10 13:11:52.577
  3              1 1          2                         0                 0                      1               2012-1-10 13:11:52.577
  4              1 1  1                         1                 0                      1               2012-3-10 13:11:52.577
  5              1 2  1                         0                 1                      1               2012-4-10 13:11:52.577
  相关解决方案