new 1.SQL
| 1 |
CREATE TABLE [dbo].[TMP_ROLE_ADVANCE_PAYMENT_SEARCH] ( |
|---|---|
| 2 |
[ROLE_NAME] [varchar](50) NULL |
| 3 |
) |
| 4 |
ON [PRIMARY] |
| 5 |
|
| 6 |
|
| 7 |
INSERT TMP_ROLE_ADVANCE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('TPGD') |
| 8 |
INSERT TMP_ROLE_ADVANCE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('GDDV') |
| 9 |
INSERT TMP_ROLE_ADVANCE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('PGD') |
| 10 |
INSERT TMP_ROLE_ADVANCE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('PTGD') |
| 11 |
INSERT TMP_ROLE_ADVANCE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('TGD') |
| 12 |
INSERT TMP_ROLE_ADVANCE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('HDQT') |
| 13 |
INSERT TMP_ROLE_ADVANCE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('TP') |
| 14 |
INSERT TMP_ROLE_ADVANCE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('PP') |
| 15 |
INSERT TMP_ROLE_ADVANCE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('TBP') |
| 16 |
INSERT TMP_ROLE_ADVANCE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('KTT') |
| 17 |
INSERT TMP_ROLE_ADVANCE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('GDK') |
| 18 |
INSERT TMP_ROLE_ADVANCE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('KSV') |
| 19 |
INSERT TMP_ROLE_ADVANCE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('TC') |
| 20 |
INSERT TMP_ROLE_ADVANCE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('NVTC') |
| 21 |
INSERT TMP_ROLE_ADVANCE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('TPTC') |
| 22 |
INSERT TMP_ROLE_ADVANCE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('PPGD') |
| 23 |
INSERT TMP_ROLE_ADVANCE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('TKTGD') |
| 24 |
INSERT TMP_ROLE_ADVANCE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('TKHDQT') |