Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
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 ]
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Database Availability Group Distribution||9||46|
|I have an unknown large SQL database I want to get rid of||10||40|
|Force XMLSEQUENCE to return empty tags for null values.||10||41|
|Query for non-UTF8 characters in a column in Oracle||11||28|
Join the community of 500,000 technology professionals and ask your questions.