제가 현재 mssql 2000 버젼을 사용중입니다.
현재 이런 쿼리가 있습니다.;;; 제가 만든건 아니지만 깁니다;;
쿼리에서 현재 selet로 결국 가져오는 값들은...
workmaster_fm, a.workmaster_idx, a.reg_dt, a.date, a.workmaster_count, a.workmaster_title, a.workmaster_content2,rank. table_gb입니다.
전 중간에 있는 worknews_gb 이 값을 selet를 하고 싶습니다.
하지만 어디에 넣어도 오류만 날뿐;;;;
asp입니다.
제가 하고 싶은건 if rs("worknews_gb ")=B then
aaaaaaaaaa
else
bbbbbbbbbb
end if
이렇게 하고 싶습니다.
한마디로 worknews_gb 이것을 어디에다 넣어야 실행이 되면서 값도 가져 올수 있을까요??
worknews_gb 이것은 kfhi_worknews_code 테이블에 들어 있는 값입니다.
고수님들 좀 제발 도와주세요..ㅠㅠ
select top 9 aa.*
from (select a.workmaster_fm, a.workmaster_idx, a.reg_dt, a.date, a.workmaster_count, a.workmaster_title, a.workmaster_content2 ,(select count(*)+1
from
(select A.workmaster_fm,A.workmaster_idx, convert(char,a.reg_dt,112) as reg_dt, convert(char,getdate()-1,112) as date,A.workmaster_count,A.workmaster_title,A.workmaster_content2, b.worknews_gb
from kfhi_worknews_master A, kfhi_worknews_code B
where A.workcode_idx = B.worknews_idx and A.workmaster_fg2 = 1 and (A.workmaster_fg3 IS NULL OR A.workmaster_fg3 = 0) and B.worknews_gb in ('B', 'F')
union all
select people_fm as workmaster_fm, people_idx as workmaster_idx, convert(char,reg_dt,112) as reg_dt, convert(char,getdate()-1,112) as date, people_count as workmaster_count, people_title as workmaster_title, people_content_pre as workmaster_content2 , people_fg
from kfhi_people
where people_fg3 = '1' and people_fg4 = '0'
union all
select emboard2_fm as workmaster_fm, emboard2_idx as workmaster_idx, convert(char,reg_dt,112) as reg_dt, convert(char,getdate()-1,112) as date, emboard2_count as workmaster_count, emboard2_title as workmaster_title, emboard2_content2 as workmaster_content2, emboard2_main_fg
from kfhi_emergency_board2master
where emboard2_fg1 = '1' and emboard2_fg2 = '0') b
where b.workmaster_idx > a.workmaster_idx ) as rank, a.table_gb
from (select A.workmaster_fm,A.workmaster_idx, convert(char,a.reg_dt,112) as reg_dt, convert(char,getdate()-1,112) as date, A.workmaster_count,A.workmaster_title,A.workmaster_content2, 'kfhi_worknews_master' as table_gb,b.worknews_gb
from kfhi_worknews_master A, kfhi_worknews_code B
where A.workcode_idx = B.worknews_idx and A.workmaster_fg2 = 1 and (A.workmaster_fg3 IS NULL OR A.workmaster_fg3 = 0) and B.worknews_gb in ('B','F')
union all
select people_fm as workmaster_fm, people_idx as workmaster_idx, convert(char,reg_dt,112) as reg_dt, convert(char,getdate()-1,112) as date, people_count as workmaster_count, people_title as workmaster_title, people_content_pre as workmaster_content2, 'kfhi_people' as table_gb, people_fg
from kfhi_people
where people_fg3 = '1' and people_fg4 = '0'
union all
select emboard2_fm as workmaster_fm, emboard2_idx as workmaster_idx, convert(char,reg_dt,112) as reg_dt, convert(char,getdate()-1,112) as date, emboard2_count as workmaster_count, emboard2_title as workmaster_title, emboard2_content2 as workmaster_content2, 'kfhi_emergency_board2master' as table_gb, emboard2_main_fg
from kfhi_emergency_board2master
where emboard2_fg1 = '1' and emboard2_fg2 = '0' ) a )aa
where rank between 1 and 3
order by rank |