Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Cross tab

Author  Topic 

AKP2008
Starting Member

45 Posts
Posted - 2009-06-25 : 03:30:51
Hi Experts,

Please help me on how to write this query.

My table data looks like

CREATE TABLE #Region
(
RegionNo varchar(50),
PlanName varchar(100),
Type varchar(100),
Age varchar(50),
Gender varchar(10),
Cost money
)

INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Youthcare','Under 1','male',187.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Youthcare','1 to 18','male',89.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber-only','19-29','male',119.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber-only','30-34','male',128.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber-only','35-39','male',147.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber-only','40-44','male',192.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber-only','45-49','male',250.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber-only','50-54','male',331.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber-only','55-59','male',443.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber-only','60-64','male',632.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber-only','19-29','female',117.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber-only','30-34','female',134.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber-only','35-39','female',156.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber-only','40-44','female',221.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber-only','45-49','female',280.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber-only','50-54','female',348.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber-only','55-59','female',453.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber-only','60-64','female',587.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber and Child','Under 30','male',213.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber and Child','30-34','male',236.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber and Child','35-39','male',281.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber and Child','40-44','male',374.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber and Child','45-49','male',521.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber and Child','50-54','male',618.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber and Child','55-59','male',819.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber and Child','60-64','male',1148.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber and Child','Under 30','female',222.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber and Child','30-34','female',244.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber and Child','35-39','female',300.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber and Child','40-44','female',426.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber and Child','45-49','female',515.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber and Child','50-54','female',639.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber and Child','55-59','female',829.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber and Child','60-64','female',1089.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber and Children','Under 30','male',362.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber and Children','30-34','male',375.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber and Children','35-39','male',451.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber and Children','40-44','male',540.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber and Children','45-49','male',665.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber and Children','50-54','male',773.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber and Children','55-59','male',946.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber and Children','60-64','male',1238.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber and Children','Under 30','female',360.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber and Children','30-34','female',376.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber and Children','35-39','female',458.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber and Children','40-44','female',604.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber and Children','45-49','female',700.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber and Children','50-54','female',787.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber and Children','55-59','female',971.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400','Subscriber and Children','60-64','female',1242.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Youthcare','Under 1','male',175.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Youthcare','1 to 18','male',99.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber-only','19-29','male',126.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber-only','30-34','male',135.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber-only','35-39','male',158.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber-only','40-44','male',207.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber-only','45-49','male',273.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber-only','50-54','male',355.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber-only','55-59','male',473.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber-only','60-64','male',674.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber-only','19-29','female',125.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber-only','30-34','female',140.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber-only','35-39','female',167.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber-only','40-44','female',238.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber-only','45-49','female',307.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber-only','50-54','female',373.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber-only','55-59','female',484.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber-only','60-64','female',625.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber and Child','Under 30','male',225.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber and Child','30-34','male',249.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber and Child','35-39','male',302.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber and Child','40-44','male',403.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber and Child','45-49','male',571.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber and Child','50-54','male',698.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber and Child','55-59','male',928.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber and Child','60-64','male',1299.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber and Child','Under 30','female',235.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber and Child','30-34','female',257.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber and Child','35-39','female',323.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber and Child','40-44','female',460.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber and Child','45-49','female',563.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber and Child','50-54','female',722.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber and Child','55-59','female',939.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber and Child','60-64','female',1232.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber and Children','Under 30','male',382.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber and Children','30-34','male',396.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber and Children','35-39','male',485.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber and Children','40-44','male',580.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber and Children','45-49','male',730.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber and Children','50-54','male',848.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber and Children','55-59','male',1036.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber and Children','60-64','male',1350.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber and Children','Under 30','female',381.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber and Children','30-34','female',396.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber and Children','35-39','female',493.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber and Children','40-44','female',649.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber and Children','45-49','female',768.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber and Children','50-54','female',863.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber and Children','55-59','female',1063.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400','Subscriber and Children','60-64','female',1353.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Youthcare','Under 1','male',114.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Youthcare','1 to 18','male',60.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber-only','19-29','male',70.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber-only','30-34','male',76.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber-only','35-39','male',95.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber-only','40-44','male',122.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber-only','45-49','male',163.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber-only','50-54','male',217.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber-only','55-59','male',294.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber-only','60-64','male',432.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber-only','19-29','female',74.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber-only','30-34','female',80.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber-only','35-39','female',101.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber-only','40-44','female',140.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber-only','45-49','female',182.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber-only','50-54','female',227.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber-only','55-59','female',300.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber-only','60-64','female',401.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber and Child','Under 30','male',137.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber and Child','30-34','male',148.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber and Child','35-39','male',181.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber and Child','40-44','male',237.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber and Child','45-49','male',341.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber and Child','50-54','male',405.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber and Child','55-59','male',548.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber and Child','60-64','male',791.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber and Child','Under 30','female',143.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber and Child','30-34','female',154.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber and Child','35-39','female',193.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber and Child','40-44','female',270.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber and Child','45-49','female',335.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber and Child','50-54','female',419.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber and Child','55-59','female',555.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber and Child','60-64','female',752.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber and Children','Under 30','male',232.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber and Children','30-34','male',236.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber and Children','35-39','male',290.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber and Children','40-44','male',325.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber and Children','45-49','male',415.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber and Children','50-54','male',492.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber and Children','55-59','male',611.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber and Children','60-64','male',822.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber and Children','Under 30','female',231.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber and Children','30-34','female',237.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber and Children','35-39','female',295.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber and Children','40-44','female',363.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber and Children','45-49','female',436.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber and Children','50-54','female',501.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber and Children','55-59','female',628.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900 Generic Rx','Subscriber and Children','60-64','female',823.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Youthcare','Under 1','male',121.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Youthcare','1 to 18','male',54.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber-only','19-29','male',66.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber-only','30-34','male',72.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber-only','35-39','male',88.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber-only','40-44','male',113.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber-only','45-49','male',149.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber-only','50-54','male',202.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber-only','55-59','male',275.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber-only','60-64','male',405.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber-only','19-29','female',70.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber-only','30-34','female',76.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber-only','35-39','female',94.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber-only','40-44','female',130.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber-only','45-49','female',166.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber-only','50-54','female',212.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber-only','55-59','female',281.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber-only','60-64','female',376.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber and Child','Under 30','male',128.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber and Child','30-34','male',148.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber and Child','35-39','male',170.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber and Child','40-44','male',220.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber and Child','45-49','male',297.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber and Child','50-54','male',377.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber and Child','55-59','male',514.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber and Child','60-64','male',744.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber and Child','Under 30','female',133.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber and Child','30-34','female',154.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber and Child','35-39','female',181.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber and Child','40-44','female',251.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber and Child','45-49','female',293.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber and Child','50-54','female',390.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber and Child','55-59','female',519.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber and Child','60-64','female',707.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber and Children','Under 30','male',217.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber and Children','30-34','male',236.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber and Children','35-39','male',272.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber and Children','40-44','male',300.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber and Children','45-49','male',378.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber and Children','50-54','male',458.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber and Children','55-59','male',573.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber and Children','60-64','male',772.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber and Children','Under 30','female',216.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber and Children','30-34','female',236.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber and Children','35-39','female',277.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber and Children','40-44','female',336.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber and Children','45-49','female',399.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber and Children','50-54','female',466.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber and Children','55-59','female',587.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900 Generic Rx','Subscriber and Children','60-64','female',773.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Youthcare','Under 1','male',127.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Youthcare','1 to 18','male',72.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber-only','19-29','male',85.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber-only','30-34','male',91.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber-only','35-39','male',115.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber-only','40-44','male',154.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber-only','45-49','male',206.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber-only','50-54','male',268.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber-only','55-59','male',360.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber-only','60-64','male',516.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber-only','19-29','female',90.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber-only','30-34','female',96.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber-only','35-39','female',122.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber-only','40-44','female',176.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber-only','45-49','female',231.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber-only','50-54','female',282.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber-only','55-59','female',369.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber-only','60-64','female',480.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber and Child','Under 30','male',165.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber and Child','30-34','male',177.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber and Child','35-39','male',220.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber and Child','40-44','male',298.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber and Child','45-49','male',431.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber and Child','50-54','male',501.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber and Child','55-59','male',674.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber and Child','60-64','male',949.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber and Child','Under 30','female',173.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber and Child','30-34','female',185.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber and Child','35-39','female',235.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber and Child','40-44','female',340.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber and Child','45-49','female',423.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber and Child','50-54','female',518.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber and Child','55-59','female',681.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber and Child','60-64','female',899.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber and Children','Under 30','male',280.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber and Children','30-34','male',284.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber and Children','35-39','male',354.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber and Children','40-44','male',408.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber and Children','45-49','male',523.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber and Children','50-54','male',609.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber and Children','55-59','male',752.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber and Children','60-64','male',985.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber and Children','Under 30','female',279.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber and Children','30-34','female',284.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber and Children','35-39','female',359.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber and Children','40-44','female',458.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber and Children','45-49','female',549.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber and Children','50-54','female',621.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber and Children','55-59','female',770.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 2900','Subscriber and Children','60-64','female',986.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Youthcare','Under 1','male',134.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Youthcare','1 to 18','male',65.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber-only','19-29','male',80.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber-only','30-34','male',87.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber-only','35-39','male',107.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber-only','40-44','male',143.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber-only','45-49','male',188.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber-only','50-54','male',250.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber-only','55-59','male',338.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber-only','60-64','male',485.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber-only','19-29','female',85.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber-only','30-34','female',91.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber-only','35-39','female',114.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber-only','40-44','female',163.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber-only','45-49','female',210.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber-only','50-54','female',263.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber-only','55-59','female',345.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber-only','60-64','female',451.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber and Child','Under 30','male',155.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber and Child','30-34','male',177.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber and Child','35-39','male',206.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber and Child','40-44','male',277.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber and Child','45-49','male',374.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber and Child','50-54','male',467.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber and Child','55-59','male',631.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber and Child','60-64','male',891.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber and Child','Under 30','female',161.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber and Child','30-34','female',185.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber and Child','35-39','female',220.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber and Child','40-44','female',316.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber and Child','45-49','female',369.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber and Child','50-54','female',483.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber and Child','55-59','female',638.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber and Child','60-64','female',846.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber and Children','Under 30','male',262.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber and Children','30-34','male',283.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber and Children','35-39','male',331.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber and Children','40-44','male',378.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber and Children','45-49','male',478.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber and Children','50-54','male',568.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber and Children','55-59','male',703.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber and Children','60-64','male',925.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber and Children','Under 30','female',261.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber and Children','30-34','female',284.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber and Children','35-39','female',336.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber and Children','40-44','female',424.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber and Children','45-49','female',502.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber and Children','50-54','female',577.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber and Children','55-59','female',721.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 2900','Subscriber and Children','60-64','female',926.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Youthcare','Under 1','male',132.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Youthcare','1 to 18','male',71.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber-only','19-29','male',83.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber-only','30-34','male',90.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber-only','35-39','male',111.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber-only','40-44','male',142.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber-only','45-49','male',188.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber-only','50-54','male',248.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber-only','55-59','male',334.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber-only','60-64','male',487.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber-only','19-29','female',88.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber-only','30-34','female',95.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber-only','35-39','female',117.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber-only','40-44','female',163.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber-only','45-49','female',210.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber-only','50-54','female',261.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber-only','55-59','female',342.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber-only','60-64','female',453.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber and Child','Under 30','male',160.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber and Child','30-34','male',174.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber and Child','35-39','male',211.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber and Child','40-44','male',277.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber and Child','45-49','male',392.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber and Child','50-54','male',463.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber and Child','55-59','male',618.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber and Child','60-64','male',886.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber and Child','Under 30','female',167.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber and Child','30-34','female',180.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber and Child','35-39','female',225.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber and Child','40-44','female',315.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber and Child','45-49','female',387.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber and Child','50-54','female',479.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber and Child','55-59','female',625.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber and Child','60-64','female',842.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber and Children','Under 30','male',271.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber and Children','30-34','male',278.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber and Children','35-39','male',339.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber and Children','40-44','male',397.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber and Children','45-49','male',499.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber and Children','50-54','male',577.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber and Children','55-59','male',713.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber and Children','60-64','male',956.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber and Children','Under 30','female',270.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber and Children','30-34','female',278.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber and Children','35-39','female',344.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber and Children','40-44','female',446.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber and Children','45-49','female',525.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber and Children','50-54','female',588.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber and Children','55-59','female',731.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900 Generic Rx','Subscriber and Children','60-64','female',957.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Youthcare','Under 1','male',141.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Youthcare','1 to 18','male',64.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber-only','19-29','male',79.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber-only','30-34','male',86.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber-only','35-39','male',103.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber-only','40-44','male',132.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber-only','45-49','male',172.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber-only','50-54','male',232.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber-only','55-59','male',313.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber-only','60-64','male',457.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber-only','19-29','female',83.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber-only','30-34','female',90.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber-only','35-39','female',110.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber-only','40-44','female',151.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber-only','45-49','female',192.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber-only','50-54','female',243.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber-only','55-59','female',320.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber-only','60-64','female',425.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber and Child','Under 30','male',150.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber and Child','30-34','male',166.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber and Child','35-39','male',197.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber and Child','40-44','male',255.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber and Child','45-49','male',349.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber and Child','50-54','male',414.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber and Child','55-59','male',559.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber and Child','60-64','male',803.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber and Child','Under 30','female',157.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber and Child','30-34','female',173.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber and Child','35-39','female',210.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber and Child','40-44','female',290.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber and Child','45-49','female',345.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber and Child','50-54','female',427.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber and Child','55-59','female',565.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber and Child','60-64','female',762.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber and Children','Under 30','male',255.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber and Children','30-34','male',265.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber and Children','35-39','male',316.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber and Children','40-44','male',346.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber and Children','45-49','male',426.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber and Children','50-54','male',501.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber and Children','55-59','male',624.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber and Children','60-64','male',834.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber and Children','Under 30','female',254.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber and Children','30-34','female',265.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber and Children','35-39','female',321.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber and Children','40-44','female',388.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber and Children','45-49','female',449.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber and Children','50-54','female',511.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber and Children','55-59','female',639.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900 Generic Rx','Subscriber and Children','60-64','female',835.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Youthcare','Under 1','male',147.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Youthcare','1 to 18','male',85.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber-only','19-29','male',100.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber-only','30-34','male',107.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber-only','35-39','male',134.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber-only','40-44','male',177.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber-only','45-49','male',236.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber-only','50-54','male',305.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber-only','55-59','male',409.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber-only','60-64','male',584.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber-only','19-29','female',105.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber-only','30-34','female',114.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber-only','35-39','female',142.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber-only','40-44','female',204.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber-only','45-49','female',264.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber-only','50-54','female',321.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber-only','55-59','female',419.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber-only','60-64','female',542.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber and Child','Under 30','male',193.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber and Child','30-34','male',208.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber and Child','35-39','male',255.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber and Child','40-44','male',346.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber and Child','45-49','male',492.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber and Child','50-54','male',571.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber and Child','55-59','male',757.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber and Child','60-64','male',1062.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber and Child','Under 30','female',201.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber and Child','30-34','female',216.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber and Child','35-39','female',272.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber and Child','40-44','female',394.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber and Child','45-49','female',484.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber and Child','50-54','female',590.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber and Child','55-59','female',766.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber and Child','60-64','female',1007.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber and Children','Under 30','male',327.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber and Children','30-34','male',332.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber and Children','35-39','male',409.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber and Children','40-44','male',498.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber and Children','45-49','male',625.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber and Children','50-54','male',712.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber and Children','55-59','male',874.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber and Children','60-64','male',1144.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber and Children','Under 30','female',325.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber and Children','30-34','female',332.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber and Children','35-39','female',416.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber and Children','40-44','female',557.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber and Children','45-49','female',659.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber and Children','50-54','female',726.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber and Children','55-59','female',896.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 900','Subscriber and Children','60-64','female',1146.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Youthcare','Under 1','male',157.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Youthcare','1 to 18','male',76.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber-only','19-29','male',94.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber-only','30-34','male',102.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber-only','35-39','male',125.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber-only','40-44','male',164.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber-only','45-49','male',214.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber-only','50-54','male',285.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber-only','55-59','male',384.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber-only','60-64','male',548.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber-only','19-29','female',100.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber-only','30-34','female',107.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber-only','35-39','female',133.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber-only','40-44','female',189.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber-only','45-49','female',241.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber-only','50-54','female',300.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber-only','55-59','female',392.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber-only','60-64','female',509.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber and Child','Under 30','male',181.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber and Child','30-34','male',200.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber and Child','35-39','male',238.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber and Child','40-44','male',319.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber and Child','45-49','male',438.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber and Child','50-54','male',511.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber and Child','55-59','male',685.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber and Child','60-64','male',961.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber and Child','Under 30','female',189.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber and Child','30-34','female',207.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber and Child','35-39','female',254.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber and Child','40-44','female',364.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber and Child','45-49','female',433.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber and Child','50-54','female',528.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber and Child','55-59','female',693.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber and Child','60-64','female',913.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber and Children','Under 30','male',307.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber and Children','30-34','male',316.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber and Children','35-39','male',384.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber and Children','40-44','male',434.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber and Children','45-49','male',534.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber and Children','50-54','male',619.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber and Children','55-59','male',764.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber and Children','60-64','male',999.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber and Children','Under 30','female',305.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber and Children','30-34','female',317.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber and Children','35-39','female',389.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber and Children','40-44','female',485.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber and Children','45-49','female',563.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber and Children','50-54','female',631.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber and Children','55-59','female',784.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 900','Subscriber and Children','60-64','female',1001.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Youthcare','Under 1','male',157.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Youthcare','1 to 18','male',83.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber-only','19-29','male',108.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber-only','30-34','male',118.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber-only','35-39','male',135.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber-only','40-44','male',179.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber-only','45-49','male',219.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber-only','50-54','male',288.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber-only','55-59','male',387.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber-only','60-64','male',562.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber-only','19-29','female',108.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber-only','30-34','female',125.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber-only','35-39','female',144.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber-only','40-44','female',191.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber-only','45-49','female',246.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber-only','50-54','female',303.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber-only','55-59','female',396.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber-only','60-64','female',523.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber and Child','Under 30','male',188.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber and Child','30-34','male',208.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber and Child','35-39','male',250.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber and Child','40-44','male',324.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber and Child','45-49','male',456.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber and Child','50-54','male',567.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber and Child','55-59','male',759.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber and Child','60-64','male',1084.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber and Child','Under 30','female',195.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber and Child','30-34','female',216.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber and Child','35-39','female',267.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber and Child','40-44','female',369.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber and Child','45-49','female',451.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber and Child','50-54','female',586.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber and Child','55-59','female',768.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber and Child','60-64','female',1029.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber and Children','Under 30','male',318.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber and Children','30-34','male',332.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber and Children','35-39','male',402.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber and Children','40-44','male',465.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber and Children','45-49','male',585.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber and Children','50-54','male',689.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber and Children','55-59','male',847.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber and Children','60-64','male',1127.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber and Children','Under 30','female',317.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber and Children','30-34','female',332.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber and Children','35-39','female',408.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber and Children','40-44','female',521.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber and Children','45-49','female',615.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber and Children','50-54','female',701.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber and Children','55-59','female',869.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '2','Vital Shield Plus 400 Generic Rx','Subscriber and Children','60-64','female',1129.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Youthcare','Under 1','male',167.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Youthcare','1 to 18','male',74.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber-only','19-29','male',102.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber-only','30-34','male',112.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber-only','35-39','male',126.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber-only','40-44','male',166.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber-only','45-49','male',200.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber-only','50-54','male',269.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber-only','55-59','male',363.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber-only','60-64','male',528.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber-only','19-29','female',102.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber-only','30-34','female',118.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber-only','35-39','female',134.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber-only','40-44','female',177.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber-only','45-49','female',224.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber-only','50-54','female',283.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber-only','55-59','female',371.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber-only','60-64','female',491.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber and Child','Under 30','male',177.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber and Child','30-34','male',197.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber and Child','35-39','male',233.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber and Child','40-44','male',300.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber and Child','45-49','male',417.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber and Child','50-54','male',502.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber and Child','55-59','male',670.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber and Child','60-64','male',958.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber and Child','Under 30','female',185.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber and Child','30-34','female',205.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber and Child','35-39','female',249.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber and Child','40-44','female',342.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber and Child','45-49','female',412.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber and Child','50-54','female',519.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber and Child','55-59','female',678.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber and Child','60-64','female',910.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber and Children','Under 30','male',301.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber and Children','30-34','male',315.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber and Children','35-39','male',374.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber and Children','40-44','male',433.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber and Children','45-49','male',532.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber and Children','50-54','male',628.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber and Children','55-59','male',774.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber and Children','60-64','male',1034.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber and Children','Under 30','female',300.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber and Children','30-34','female',315.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber and Children','35-39','female',380.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber and Children','40-44','female',484.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber and Children','45-49','female',560.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber and Children','50-54','female',639.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber and Children','55-59','female',793.0000 )
INSERT INTO #Region ([RegionNo] ,[PlanName] ,[Type] ,[Age] ,[Gender] ,[Cost] ) VALUES ( '1','Vital Shield Plus 400 Generic Rx','Subscriber and Children','60-64','female',1037.0000 )

Required output is

Gender RegionNo PlanName Subscriber-only Subscriber and Spouse/ domestic parter Subscriber and Children Youthcare Family Subscriber and Child
female 2 Vital Shield Plus 2900 Generic Rx NULL NULL Under 30 NULL NULL Under 30
female 2 Vital Shield Plus 2900 Generic Rx 19-29 NULL NULL NULL NULL NULL
female 2 Vital Shield Plus 2900 Generic Rx 30-34 NULL 30-34 NULL NULL 30-34
female 2 Vital Shield Plus 2900 Generic Rx 35-39 NULL 35-39 NULL NULL 35-39
female 2 Vital Shield Plus 2900 Generic Rx 40-44 NULL 40-44 NULL NULL 40-44
female 2 Vital Shield Plus 2900 Generic Rx 45-49 NULL 45-49 NULL NULL 45-49
female 2 Vital Shield Plus 2900 Generic Rx 50-54 NULL 50-54 NULL NULL 50-54
female 2 Vital Shield Plus 2900 Generic Rx 55-59 NULL 55-59 NULL NULL 55-59
female Vital Shield Plus 2900 Generic Rx 60-64 NULL 60-64 NULL NULL 60-64
male 2 Vital Shield Plus 2900 Generic Rx NULL NULL NULL Under 1 NULL NULL
male 2 Vital Shield Plus 2900 Generic Rx NULL NULL Under 30 NULL NULL Under 30
male 2 Vital Shield Plus 2900 Generic Rx NULL NULL NULL 1 to 18 NULL NULL
male 2 Vital Shield Plus 2900 Generic Rx 19-29 NULL NULL NULL NULL NULL
male 2 Vital Shield Plus 2900 Generic Rx 30-34 NULL 30-34 NULL NULL 30-34
male 2 Vital Shield Plus 2900 Generic Rx 35-39 NULL 35-39 NULL NULL 35-39
male 2 Vital Shield Plus 2900 Generic Rx 40-44 NULL 40-44 NULL NULL 40-44
male 2 Vital Shield Plus 2900 Generic Rx 45-49 NULL 45-49 NULL NULL 45-49
male 2 Vital Shield Plus 2900 Generic Rx 50-54 NULL 50-54 NULL NULL 50-54
male 2 Vital Shield Plus 2900 Generic Rx 55-59 NULL 55-59 NULL NULL 55-59
male 2 Vital Shield Plus 2900 Generic Rx 60-64 NULL 60-64 NULL NULL 60-64

like this i want to get for all regions.
I tried with this but i am unable to get the correct data

DECLARE @StrSql VARCHAR(MAX)
DECLARE @SQL VARCHAR(MAX)

SET @StrSql = ''
SELECT @StrSql = @StrSql + ', CASE WHEN Type = ''' + Type + '''
THEN Age ELSE NULL END "' + Type +'"'
FROM (select distinct type from #region
where isnull(type , '') <> '') T

select @StrSql = stuff(@StrSql, 1, 1, '')

select @StrSql

SET @SQL = ''

-- Final Result
SELECT @SQL = 'SELECT distinct planname, regionno, gender, ' + @STRSQL + ' FROM #Region'


PRINT @SQL
EXEC(@SQL)

How can i do this. Please help.

Thanks in Advance.

SwePeso
Patron Saint of Lost Yaks

30421 Posts
Posted - 2009-06-25 : 03:54:58
Something like this?
DECLARE	@SQL VARCHAR(MAX)

SET	@SQL = ''

SELECT	@SQL = @SQL + ', MAX(CASE WHEN [Type] = ' + QUOTENAME([Type], '''')
		+ 'THEN Age ELSE NULL END) AS ' + QUOTENAME(Type)
FROM	(
		SELECT	DISTINCT
			[Type]
		FROM	#Region 
		WHERE	[Type] IS NOT NULL
	) AS d

-- Final Result
SET	@SQL = 'SELECT PlanName, RegionNo, Gender' + @SQL
		+ ' FROM #Region GROUP BY PlanName, RegionNo, Gender ORDER BY PlanName, RegionNo, Gender' 

PRINT @SQL
EXEC(@SQL)


E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts
Posted - 2009-06-25 : 04:09:51
using PIVOT

declare @SQL	nvarchar(max),
	@COL	nvarchar(max)

select	@COL 	= ISNULL(@COL + ',', '') + quotename(Type)
from	#Region
group by Type

select	@SQL	= 'select	Gender, RegionNo, PlanName' + ',' + @COL 	+ char(13)
select	@SQL	= @SQL + 'from  #Region r ' 					+ char(13)
select	@SQL	= @SQL + 'PIVOT'						+ char(13)
select	@SQL	= @SQL + '('							+ char(13)
select	@SQL	= @SQL + '	MAX(Age)'					+ char(13)
select	@SQL	= @SQL + '	FOR Type IN (' + @COL + ')'			+ char(13)
select	@SQL	= @SQL + ') as P'						+ char(13)
PRINT @SQL
EXEC (@SQL)


KH
[spoiler]Time is always against us[/spoiler]
Go to Top of Page

AKP2008
Starting Member

45 Posts
Posted - 2009-06-25 : 04:26:05
Hi,

Thanks for your response.

With Peso solution i am getting only max record in that region.

Khtan solution displaying duplicate records.

I want to get all ages if not exists return null.
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts
Posted - 2009-06-25 : 04:32:05
Oh. . . didn't notice you have a cost column in the #Region table


declare @SQL	nvarchar(max),
	@COL	nvarchar(max)

select	@COL 	= ISNULL(@COL + ',', '') + quotename(Type)
from	#Region
group by Type

select	@SQL	= 'SELECT	Gender, RegionNo, PlanName' + ',' + @COL 		+ char(13)
select	@SQL	= @SQL + 'FROM  ' 							+ char(13)
select	@SQL	= @SQL + '('								+ char(13)
select	@SQL	= @SQL + '	SELECT DISTINCT Gender, RegionNo, PlanName, Age, Type'	+ char(13)
select	@SQL	= @SQL + '	FROM   #Region' 					+ char(13)
select	@SQL	= @SQL + ') AS r'							+ char(13)
select	@SQL	= @SQL + 'PIVOT'							+ char(13)
select	@SQL	= @SQL + '('								+ char(13)
select	@SQL	= @SQL + '	MAX(Age)'						+ char(13)
select	@SQL	= @SQL + '	FOR Type IN (' + @COL + ')'				+ char(13)
select	@SQL	= @SQL + ') AS p'							+ char(13)
PRINT @SQL
EXEC (@SQL)


KH
[spoiler]Time is always against us[/spoiler]
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts
Posted - 2009-06-25 : 04:47:01
This?
DECLARE	@SQL VARCHAR(MAX)

SET	@SQL = ''

SELECT	@SQL = @SQL + ', MAX(CASE WHEN r.[Type] = ' + QUOTENAME([Type], '''')
		+ ' AND r.Age = a.Age THEN r.Age ELSE NULL END) AS ' + QUOTENAME(Type)
FROM		(
			SELECT	DISTINCT
				[Type]
			FROM	#Region 
			WHERE	[Type] IS NOT NULL
		) AS d

-- Final Result
SET	@SQL = '
SELECT		r.Gender,
		r.RegionNo,
		r.PlanName' + @SQL + '
FROM		#Region AS r
CROSS JOIN	(
			SELECT	DISTINCT
				Age
			FROM	#Region
		) AS a
GROUP BY	r.Gender,
		r.RegionNo,
		r.PlanName,
		a.Age
ORDER BY	r.Gender,
		r.RegionNo,
		r.PlanName' 

PRINT @SQL
EXEC(@SQL)


E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

AKP2008
Starting Member

45 Posts
Posted - 2009-06-25 : 06:21:14
Thanks for your Help..

I got the Result.
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts
Posted - 2009-06-25 : 06:44:15
06/25/2009 : 04:32:05 or 06/25/2009 : 04:47:01 ?

E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site