|
use hodo;
CREATE TABLE #tmp_stat
(
base_term INTEGER NOT NULL DEFAULT '0' PRIMARY KEY,
base_text CHAR(8) NOT NULL DEFAULT '',
group0 INTEGER NOT NULL DEFAULT '0',
group1 INTEGER NOT NULL DEFAULT '0',
group2 INTEGER NOT NULL DEFAULT '0',
group3 INTEGER NOT NULL DEFAULT '0',
sub_tot INTEGER NOT NULL DEFAULT '0'
);
INSERT INTO #tmp_stat (base_term) VALUES (0);
INSERT INTO #tmp_stat (base_term) VALUES (1);
INSERT INTO #tmp_stat (base_term) VALUES (2);
INSERT INTO #tmp_stat (base_term) VALUES (3);
INSERT INTO #tmp_stat (base_term) VALUES (4);
INSERT INTO #tmp_stat (base_term) VALUES (5);
INSERT INTO #tmp_stat (base_term) VALUES (6);
INSERT INTO #tmp_stat (base_term) VALUES (7);
INSERT INTO #tmp_stat (base_term) VALUES (8);
INSERT INTO #tmp_stat (base_term) VALUES (9);
INSERT INTO #tmp_stat (base_term) VALUES (10);
INSERT INTO #tmp_stat (base_term) VALUES (11);
INSERT INTO #tmp_stat (base_term) VALUES (12);
INSERT INTO #tmp_stat (base_term) VALUES (13);
INSERT INTO #tmp_stat (base_term) VALUES (14);
INSERT INTO #tmp_stat (base_term) VALUES (15);
INSERT INTO #tmp_stat (base_term) VALUES (16);
INSERT INTO #tmp_stat (base_term) VALUES (17);
INSERT INTO #tmp_stat (base_term) VALUES (18);
INSERT INTO #tmp_stat (base_term) VALUES (19);
INSERT INTO #tmp_stat (base_term) VALUES (20);
INSERT INTO #tmp_stat (base_term) VALUES (21);
INSERT INTO #tmp_stat (base_term) VALUES (22);
INSERT INTO #tmp_stat (base_term) VALUES (23);
UPDATE #tmp_stat
SET base_text = convert(varchar, base_term)+ '~'+convert(varchar,base_term+1)+ '시';
CREATE TABLE #tmp_tmp
(
base_term INTEGER NOT NULL DEFAULT '0',
group_num CHAR(10) NOT NULL DEFAULT '',
cnt INTEGER NOT NULL DEFAULT '0',
PRIMARY KEY (base_term, group_num)
);
INSERT INTO #tmp_tmp (base_term, group_num, cnt)
SELECT cast( substring(c_intime,1,2) as int), state, COUNT(*)
FROM calltb
WHERE gubun = '수신'
GROUP BY cast( substring(c_intime,1,2) as int), state;
UPDATE #tmp_stat
SET #tmp_stat.group0 = #tmp_tmp.cnt
from #tmp_tmp
WHERE #tmp_stat.base_term = #tmp_tmp.base_term AND #tmp_tmp.group_num = '포기호';
UPDATE #tmp_stat
SET #tmp_stat.group1 = #tmp_tmp.cnt
from #tmp_tmp
WHERE #tmp_stat.base_term = #tmp_tmp.base_term AND #tmp_tmp.group_num = '상담';
UPDATE #tmp_stat
SET #tmp_stat.group2 = #tmp_tmp.cnt
from #tmp_tmp
WHERE #tmp_stat.base_term = #tmp_tmp.base_term AND #tmp_tmp.group_num = '대기호';
UPDATE #tmp_stat
SET #tmp_stat.group3 = #tmp_tmp.cnt
from #tmp_tmp
WHERE #tmp_stat.base_term = #tmp_tmp.base_term AND #tmp_tmp.group_num = '콜백';
UPDATE #tmp_stat
SET sub_tot = group0 + group1 + group2 + group3 ;
DROP TABLE #tmp_tmp;
SELECT *
FROM #tmp_stat
WHERE base_term > 8 AND base_term < 18
ORDER BY base_term;
위 퀴리를 프로그램에서 실행하면 error create handle이라고 메시지가 나옵니다.
퀴리프라우저에서는 작동되는데
제 프로그램에서 실행(빌더6.0)에서 실행하니 위와 같은 에러메시지가 나오는데 ...
도움을 구합니다. |
