Hi AllI have a union query which retreives information from two differant requests compares them and displays YES,NO,NA based on the comparison in a third row.Below is my SQL querySELECT CAST(RR.reqestno AS VARCHAR(MAX)) reqestno,CAST(RR.receiveddate AS VARCHAR(MAX)) AS receiveddate,CAST(RR.rptcomments AS VARCHAR(MAX)) AS rptcomments,CAST(RR.reportfrequency AS VARCHAR(MAX)) AS reportfrequency,CAST(RR.schedule AS VARCHAR(MAX)) AS schedule,CAST(RR.schedulebasedon AS VARCHAR(MAX)) AS schedulebasedon,CAST(RR.clmsrvdtfrom AS VARCHAR(MAX)) AS clmsrvdtfrom,CAST(RR.clmsrvdtthru AS VARCHAR(MAX)) AS clmsrvdtthru,CAST(RR.clmpddtfrom AS VARCHAR(MAX)) AS clmpddtfrom,CAST(RR.clmpddtthru AS VARCHAR(MAX)) AS clmpddtthru,CAST(RR.customer AS VARCHAR(MAX)) AS customerfrom REPORT_REQUEST RR where RR.reqestno = xxxxxxUNION ALLSELECT CAST(RR.reqestno AS VARCHAR(MAX)) reqestno,CAST(RR.receiveddate AS VARCHAR(MAX)) AS receiveddate,CAST(RR.rptcomments AS VARCHAR(MAX)) AS rptcomments,CAST(RR.reportfrequency AS VARCHAR(MAX)) AS reportfrequency,CAST(RR.schedule AS VARCHAR(MAX)) AS schedule,CAST(RR.schedulebasedon AS VARCHAR(MAX)) AS schedulebasedon,CAST(RR.clmsrvdtfrom AS VARCHAR(MAX)) AS clmsrvdtfrom,CAST(RR.clmsrvdtthru AS VARCHAR(MAX)) AS clmsrvdtthru,CAST(RR.clmpddtfrom AS VARCHAR(MAX)) AS clmpddtfrom,CAST(RR.clmpddtthru AS VARCHAR(MAX)) AS clmpddtthru,CAST(RR.customer AS VARCHAR(MAX)) AS customerfrom REPORT_REQUEST RR where RR.reqestno = yyyyyyUNION ALLSELECT CASE WHEN A.reqestno = B.reqestno THEN 'Yes' ELSE 'No' END as reqestno, CASE WHEN A.receiveddate = B.receiveddate THEN 'Yes' ELSE 'No' END as receiveddate, CASE WHEN A.rptcomments is null and B.rptcomments is null then 'NA' WHEN A.rptcomments = B.rptcomments THEN 'Yes' ELSE 'No' END rptcomments, CASE WHEN A.reportfrequency = B.reportfrequency THEN 'Yes' ELSE 'No' END as reportfrequency, CASE WHEN A.schedule = 'NONE' and B.schedule = 'NONE' THEN 'NA'WHEN A.schedule = B.schedule THEN 'Yes' ELSE 'No' END as schedule, CASE WHEN A.schedulebasedon = 'NONE' and B.schedulebasedon = 'NONE' THEN 'NA' WHEN A.schedulebasedon = B.schedulebasedon THEN 'Yes' ELSE 'No' END as schedulebasedon, CASE WHEN A.clmsrvdtfrom is null and B.clmsrvdtfrom is Null Then 'NA' WHEN A.clmsrvdtfrom = B.clmsrvdtfrom THEN 'Yes' ELSE 'No' END as clmsrvdtfrom, CASE WHEN A.clmsrvdtthru is null and B.clmsrvdtthru is null then 'NA' WHEN A.clmsrvdtthru = B.clmsrvdtthru THEN 'Yes' ELSE 'No' END as clmsrvdtthru, CASE WHEN A.clmpddtfrom is Null and B.clmpddtfrom is null then 'NA' WHEN A.clmpddtfrom = B.clmpddtfrom THEN 'Yes' ELSE 'No' END as clmpddtfrom, CASE WHEN A.clmpddtthru is null and B.clmpddtthru is null then 'NA' WHEN A.clmpddtthru = B.clmpddtthru THEN 'Yes' ELSE 'No' END as clmpddtthru, CASE WHEN A.customer = B.customer THEN 'Yes' ELSE 'No' END as customer FROM (SELECT reqestno,receiveddate,rptcomments,reportfrequency,schedule,schedulebasedon,clmsrvdtfrom,clmsrvdtthru,clmpddtfrom,clmpddtthru,customer FROM REPORT_REQUEST WHERE reqestno = xxxxxx) AS AINNER JOIN (SELECT reqestno,receiveddate,rptcomments,reportfrequency,schedule,schedulebasedon,clmsrvdtfrom,clmsrvdtthru,clmpddtfrom,clmpddtthru,customer FROM REPORT_REQUEST WHERE reqestno = yyyyyy) AS B ON 1 = 1
QuestionHow should i edit the above query to make it display only columns that have only a value of 'NO' after comparison and in some way hide the other columns whereever comparison returns YES or NASample Resultsrequestno receiveddate rptcomments reportfrequency schedule schedulebasedon clmsrvdtfrom clmsrvdtthru clmpddtfrom clmpddtthru customer300431 Nov 29 2012 10:28AM Recurring Calendar Year May 1 2012 12:00AM Oct 31 2012 12:00AM Jan 1 1900 12:00AM Jan 1 1900 12:00AM LIFTONE, LLC223681 Jan 18 2011 9:49AM Please clone from 2010 request. T. Rowe is "sliced business" with UHC and Carefirst. They are moving to a Datza Warehouse to gain a full picture of their population. Data Warehousing: UHC to submit via FTP monthly medical claims to Thompson Reuters Recurring Calendar Year Jan 1 1900 12:00AM Jan 1 1900 12:00AM Jan 1 2011 12:00AM Jan 31 2011 12:00AM T. ROWE PRICE GROUP, INC.No No No Yes NA Yes No No No No NoNeed help pleaseThanks in advance