Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
-- 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 ]
Join the community of 500,000 technology professionals and ask your questions.