You can accomplished this using below query:

;WITH CTE AS

(

SELECT [Pax ID],[Flight Date],[Flight Number],[Last Mod Date],[status]

FROM PNRAdds

UNION ALL

SELECT [Pax ID],[Flight Date],[Flight Number],[Last Mod Date],[status]

FROM PNRUpdates

...

You can use below query for this:

select country_name, region_name,COUNT(region_name)total

FROM samples

group by country_name, region_name

Hi,

you can also do this usinf Except -

;WITH CTE AS

(

SELECT MachineName, GroupName

FROM

(SELECT distinct A.MachineName

FROM #MachineGroups A)C

CROSS JOIN

(SELECT distinct B.GroupName

FROM #MachineGroups B)D

)

SELECT C.MachineName, C.GroupName

FROM CTE C

EXCEPT

SELECT M.MachineName,...

Hi,

Instead of using UNION ALL you put can use Join and select out the common data from your table and after that you can add a column as a flag...

Hi,

Can you please post the actual execution plan and statistics ?

Thanks all for your suggestion

I have updated this one as:

--BEGIN TRAN ROLLBACK

SELECT

CASE WHEN Division = 'AWT' THEN

CASE WHEN Product_Line = 'N' THEN

CASE WHEN Product_Type = 'AG' THEN

CASE WHEN AWT_Tank_Size = 120 THEN...

Eirikur Eiriksson (11/25/2014)

---

Fundamental error here, ELSE is the last / unmatched clause, not a part of the higher case flow hierarchy, suggest you remove all but the last else statements...

you can use join for that...

sorry, posted the wrong desired output..

please seet he modified one

Can you please provide table scripts and some sample data, that would be easier for us to understand the scenario

You can also follow the STAIRWAYS link available in this site only....

You can learn many new things from there other than reporting services 🙂

Please provide table structure and sample data for this....

Does it make any impact if I used SET NOCOUNT...

Only Select