質問編集履歴
1
追記
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -21,4 +21,13 @@
|
|
|
21
21
|
AND member_type = '01'
|
|
22
22
|
NOT in (shitei < update_datetime)
|
|
23
23
|
AND (enable_flg = 0)
|
|
24
|
-
```
|
|
24
|
+
```
|
|
25
|
+
|
|
26
|
+
追記
|
|
27
|
+
sql += "DECRARE @kensu INT";
|
|
28
|
+
sql += "SELECT @kensuu = shitei as TRANSITION_YEAR COUNT(*) as TRANSITION_COUNT";
|
|
29
|
+
sql += "FROM tm_user_enc ";
|
|
30
|
+
sql += "WHERE shitei >= create_datetime";
|
|
31
|
+
sql += "AND member_type = '01' ";
|
|
32
|
+
sql += "NOT in (shitei < update_datetime)";
|
|
33
|
+
sql += "AND (enable_flg = 0)";
|