July's Course of the Month is now available! Enroll to learn HTML5 and prepare for certification. It's free for Premium Members, Team Accounts, and Qualified Experts.
-- This query returns 101 row of records. select svc_pvr_pyr_nr from tcomgrp where sls_grp_cd ='IS' and sales_vew_cd ='S1709' and dat_cx_tm_prd_nr = '85' minus select svc_pvr_pyr_nr from tcomgrp where sls_grp_cd ='IS' and sales_vew_cd ='S1709' and dat_cx_tm_prd_nr = '0'; -- I have to pass each row of record into the select query paramter and insert the Temp Table.x`x` CREATE TABLE TempTCompGRP_Context_0 AS SELECT * FROM TCOMGRP WHERE SLS_GRP_CD ='IS' AND SALES_VEW_CD ='S1709' AND DAT_CX_TM_PRD_NR = '85' AND SVC_PVR_PYR_NR = [ VALUE WHICH I GET FROM MINUS QUERY ]
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.