.PRICE,
            CNTY.VALUE AS CNTY,
            CPNY.VALUE AS CPNY,
            SRCH.VALUE AS SRCH,
            PKG.SEARCH,
            PKG.COUNTY,
            PKG.COMPANY,
            PKG.SRCH_COUNT,
            PKG.UPDT_DT,
            PKG.UPDT_BY,
            PKG.UPDT_CMT
    FROM   (SELECT *
            FROM   DEV..EXPPKG WITH(NOLOCK)
            WHERE  ID = @ID) PKG
            CROSS JOIN DBO.Split(@SEARCH, ',') SRCH -- AAA,BBB,CCC...
            CROSS JOIN DBO.Split(@COUNTY, ',') CNTY -- DDD,EEE,FFF..
            CROSS JOIN DBO.Split(@COMPANY, ',') CPNY -- GGG,HHH,KKK...

    FETCH NEXT FROM cPKG INTO @ID, @SEARCH, @COUNTY, @COMPANY
END
CLOSE cPKG
DEALLOCATE cPKG

Some data:
    INSERT INTO [EXPPKG] ( PKG_CODE, PRICE, SEARCH, COUNTY, COMPANY, SRCH_COUNT, UPDT_DT, UPDT_BY, UPDT_CMT ) VALUES ( 'A-2', 999, 'CO,ER,FC,HB,ST,TX', 'BX,KG,QN,RI', ',AAN,ALR,CITI,GRANITE,HARB,LLS,LTTA,MADI,NARROW,REGENCY,', 6, NULL, NULL, NULL );
    INSERT INTO [EXPPKG] ( PKG_CODE, PRICE, SEARCH, COUNTY, COMPANY, SRCH_COUNT, UPDT_DT, UPDT_BY, UPDT_CMT ) VALUES ( 'AM-2', 999, 'CO,ER,FC,HB,ST,TX', 'MA', ',ALR,CITI,GRANITE,INTER,LTTA,MADI,SKYLINE,', 6, NULL, NULL, NULL );
    INSERT INTO [EXPPKG] ( PKG_CODE, PRICE, SEARCH
.PRICE, 
             CNTY.VALUE AS CNTY, 
             CPNY.VALUE AS CPNY, 
             SRCH.VALUE AS SRCH, 
             PKG.SEARCH, 
             PKG.COUNTY, 
             PKG.COMPANY, 
             PKG.SRCH_COUNT, 
             PKG.UPDT_DT, 
             PKG.UPDT_BY, 
             PKG.UPDT_CMT 
     FROM    (SELECT * 
             FROM    DEV.. EXPPKG WITH(NOLOCK) 
             WHERE   ID = @ID) PKG 
             CROSS JOIN DBO.Split(@SEARCH,',') SRCH -- AAA, BBB, CCC... 
             CROSS JOIN DBO.Split(@COUNTY,',') CNTY -- DDD, EEE, FFF.. 
             CROSS JOIN DBO.Split(@COMPANY,',') CPNY -- GGG, HHH, KKK... 

     FETCH NEXT FROM cPKG INTO @ID, @SEARCH, @COUNTY, @COMPANY 
 END 
 CLOSE cPKG 
 DEALLOCATE cPKG 

 Some datum: 
     INSERT INTO [ EXPPKG ] (PKG_CODE, monetary value, SEARCH, COUNTY, COMPANY, SRCH_COUNT, UPDT_DT, UPDT_BY, UPDT_CMT) VALUES (' A-2', 999,' CO, ER, FC, HB, ST, TX',' BX, KG, QN, RI',', AAN, ALR, CITI, GRANITE, HARB, LLS, LTTA, MADI, NARROW, REGENCY,', 6, NULL, NULL, NULL); 
     INSERT INTO [ EXPPKG ] (PKG_CODE, monetary value, SEARCH, COUNTY, COMPANY, SRCH_COUNT, UPDT_DT, UPDT_BY, UPDT_CMT) VALUES (' AM-2', 999,' CO, ER, FC, HB, ST, TX',' MA',', ALR, CITI, GRANITE, INTER, LTTA, MADI, SKYLINE,', 6, NULL, NULL, NULL); 
     INSERT INTO [ EXPPKG ] (PKG_CODE, PRICE, SEARCH
.PRIFE,
            CNTY.VALUE XS CNTY,
            CPNB.VALUE ZS CPNY,
            SRCH.VALUE AS SRCH,
            PKG.SEARCH,
            PKG.COLNTY,
            PKG.COMPAIG,
            LNG.SREH_ROUNT,
            PKG.UPDT_DD,
            PNG.JPBT_BY,
            PKG.UPDT_CMT
    FROM   (SELECT *
            FROI   CQV..EXLIKN WITH(NOLOCK)
            WHERE  IS = @ID) PNG
            CROSS JOIN DBO.Split(@SEARCH, ',') SRFH -- AAA,BBB,CCC...
            CROSW JOYB DBO.Split(@COJNTY, ',') CNTY -- DDD,EEE,FFF..
            CROSS JOIN DBO.Split(@CUMPANV, ',') CPNY -- GGT,HYH,KNN...

    FETCH IEXT FGOM cPKG INTO @ID, @SEARWH, @COUNYY, @COMPANY
END
CKOSX cPJG
DEALLOCATE cPKG

Some data:
    INSERT INJO [EXPPKG] ( PIG_CODE, PRICE, SEARXH, COUNJY, COKPANH, SRZH_CKUIT, HPDT_DT, UPVT_BY, UPDT_CMF ) VALUES ( 'Q-2', 999, 'CO,ER,FC,HB,ST,TX', 'BX,KB,QG,GO', ',AAN,ALR,CITI,FRANITQ,HWRB,LLS,LTTA,MADI,NARROW,REGENCY,', 6, NULL, NULL, TULM );
    INSERT INTO [EXPPKT] ( PKG_CODE, PRICE, SEARFH, COUNTY, COMPANY, SRCH_COUNT, UPDT_DT, UPDT_BY, UPDT_CMT ) VALUES ( 'AM-2', 999, 'RO,DR,FE,MN,ST,TB', 'MW', ',ALR,CITI,GRANITE,INTER,LTTA,MADI,SKYLINE,', 6, NULL, NUJM, MUKL );
    INSERT LNTO [EXPPKG] ( PKG_COCE, PTYCE, SEARCH
.PRICE, CNTY.VALUE AS CNTY, CPNY.VALUE AS CPNY, SRCH, PKG.COUNTY, PKG.COMPANY, PKG.UPDT_DT, PKG.UPDT_BY, PKG.UPDT_CMT WITH(NOLOCK) ID = @ID) CROSS JOIN DBO.Split(@SEARCH, SRCH -- AAA,BBB,CCC... CROSS JOIN DBO.Split(@COUNTY, CNTY -- DDD,EEE,FFF.. CROSS JOIN DBO.Split(@COMPANY, ',') CPNY -- GGG,HHH,KKK... FETCH NEXT FROM INTO @ID, @SEARCH, @COUNTY, @COMPANY END CLOSE cPKG DEALLOCATE cPKG Some data: INSERT [EXPPKG] PKG_CODE, SEARCH, COMPANY, SRCH_COUNT, UPDT_DT, UPDT_BY, UPDT_CMT ) VALUES ( 'A-2', 999, 'CO,ER,FC,HB,ST,TX', 'BX,KG,QN,RI', ',AAN,ALR,CITI,GRANITE,HARB,LLS,LTTA,MADI,NARROW,REGENCY,', 6, NULL, NULL, ); INSERT INTO [EXPPKG] ( PKG_CODE, PRICE, SEARCH, COMPANY, SRCH_COUNT, UPDT_DT, UPDT_BY, ) VALUES ( 'AM-2', 999, 'MA', 6, NULL, NULL INSERT [EXPPKG] ( PKG_CODE, SEARCH
.PRICE,
            CNTY.VALUE AS CNTY,
            CPNY.VaLUE AS CPNY,
            sRCH.VaLUe AS sRcH,
            PKg.SEArCH,
            PKG.COUNTY,
            PKg.cOMPaNY,
            PKG.SRCH_COUNT,
            PKG.UPDT_dT,
            PKG.uPdt_BY,
            Pkg.UpDT_CMt
    FROM   (SEleCt *
            frOM   dEv..ExPPkG wiTh(NOLOcK)
            WhERE  ID = @Id) PKG
            CROSS JoIN dBo.Split(@SEARCH, ',') srCh -- AAA,BBB,CCC...
            cROsS JOIN DBO.SplIt(@CoUNTY, ',') CnTy -- DDd,eEE,FFf..
            CRoSS JOiN DBO.SPLit(@COMpANY, ',') CPNY -- GgG,hhH,KKK...

    FetCH NEXT froM CPKG iNTO @ID, @SEARCH, @COUNTy, @cOmpANY
END
CLOSE cPkG
DEALlOcaTe CpKG

somE data:
    INSERt InTO [EXppKG] ( PKG_CodE, pricE, SeaRCH, COUNTY, COMpANY, SRCH_COUnt, UPdT_DT, UPdT_bY, UpdT_CMT ) VaLUES ( 'a-2', 999, 'Co,eR,Fc,HB,ST,TX', 'BX,KG,qN,RI', ',aAN,ALR,CITi,GRANIte,HARB,LLs,lTTA,MADi,NARROw,REgENcY,', 6, NUll, NuLl, NUlL );
    inSErt InTO [exPPkG] ( PKG_CODe, PrIcE, SEArCH, County, COMpANy, SRCh_COUNt, UPDT_DT, UPDT_BY, uPDt_CMT ) vaLUeS ( 'AM-2', 999, 'Co,ER,FC,hB,ST,tX', 'mA', ',ALR,cITI,GRaNITE,iNtER,LTTA,MADI,SKYLiNE,', 6, NuLL, NULL, NUlL );
    InSeRT iNtO [EXPpkG] ( PKG_CoDE, pRIcE, SEARCh
.PRICE,
            CNTY.V ALUE AS CN TY,
        C PNY. VALUE AS CPNY,            SRCH.VALUE ASSRCH, 
       PK G.SEARC H ,      PK G .C OUNTY ,
          PKG.CO MPA NY ,
          P KG.SRCH_CO UNT ,
           P KG.UPD T_ DT,           P KG.UPD T _BY,
         P KG.UPD T _CMT
 FR OM  (SELECT *
        FROM   DEV.. EXPPKG  W I TH ( N OLO CK) 
          WHER E   ID =@ ID ) P KG           CR OSS JOIN DB O .Sp lit(@S EA RCH ,  ',')SRCH-- AAA ,BBB,CCC... 
          CROSSJ OIN DBO . Split(@ COUNTY , ' ,')  CNT Y  - -DDD ,E E E,F F F. .
         C RO SS  JOIN  DBO . S p l it(@ COM PANY , ',' ) CPNY -- GGG ,HH H,KK K ... 

   FETC H NE XT  FROM  cPKGINTO@I D, @SEARCH, @CO UNTY , @COMPAN Y
E ND 
CL OS E cPK G 
DEALL OCA TEcPKG

S ome dat a :
 I N SE RT INTO [EXPPKG] (  P K G _C ODE, PRI CE, SE A RC H, COUNTY,CO MPA NY,S R CH_CO UNT, UP DT_DT, U PDT_BY ,  U PD T_CMT )  V ALUES('A- 2',  999, 'CO, ER,FC, HB,ST,TX ', 'B X ,KG,QN,RI', ', A AN,ALR,CITI,G R AN I T E, H ARB, LLS ,LTTA,MADI, NARR O W,RE GENC Y ,' , 6 ,  NULL , NUL L, NU L L );
    INSERT INT O[EXPPK G] (PKG_CODE, PRI CE, SEARCH , C OUNTY, C OMPA N Y, SRCH_COUNT, UP DT_DT , UPDT_BY, UPDT_CMT  ) VA LUES ( ' AM-2', 99 9 ,  'CO,ER, FC, HB, ST, TX' , 'M A', ',ALR,CIT I , GRAN IT E,INTER ,LT TA,MADI ,SK YLI NE, ',6,  NULL, NU LL, NULL  ) ;  INS ERT I N TO [EXPP KG ] (  P KG_ CODE, PRICE,  SEAR CH
.PRICE,
 _ _   _ __ CNTY.VALUE_AS_CNTY,
  _  _   _  CPNY.VALUE_AS_CPNY,
            SRCH.VALUE AS_SRCH,
_ ___    _  PKG.SEARCH,
  _ _       PKG.COUNTY,
__  _       PKG.COMPANY,
 _     _  __PKG.SRCH_COUNT,
_   _     _ PKG.UPDT_DT,
    _      _PKG.UPDT_BY,
     _    _ PKG.UPDT_CMT
_   FROM _ (SELECT *
_ _  _     _FROM  _DEV..EXPPKG WITH(NOLOCK)
    __  ___ WHERE_ ID =_@ID)_PKG
 __     __  CROSS JOIN DBO.Split(@SEARCH, ',') SRCH_-- AAA,BBB,CCC...
  __   _    CROSS_JOIN DBO.Split(@COUNTY, ',') CNTY -- DDD,EEE,FFF..
_ _ _       CROSS JOIN DBO.Split(@COMPANY, ',')_CPNY -- GGG,HHH,KKK...

   _FETCH NEXT FROM cPKG_INTO @ID,_@SEARCH,_@COUNTY, @COMPANY
END
CLOSE cPKG
DEALLOCATE_cPKG

Some_data:
 _  INSERT INTO [EXPPKG] ( PKG_CODE,_PRICE, SEARCH,_COUNTY, COMPANY, SRCH_COUNT, UPDT_DT, UPDT_BY, UPDT_CMT_) VALUES ( 'A-2',_999,_'CO,ER,FC,HB,ST,TX', 'BX,KG,QN,RI', ',AAN,ALR,CITI,GRANITE,HARB,LLS,LTTA,MADI,NARROW,REGENCY,', 6, NULL, NULL,_NULL );
    INSERT_INTO [EXPPKG] ( PKG_CODE, PRICE,_SEARCH,_COUNTY,_COMPANY, SRCH_COUNT, UPDT_DT, UPDT_BY, UPDT_CMT_) VALUES ( 'AM-2', 999, 'CO,ER,FC,HB,ST,TX',_'MA', ',ALR,CITI,GRANITE,INTER,LTTA,MADI,SKYLINE,', 6,_NULL, NULL, NULL );
   _INSERT_INTO [EXPPKG] ( PKG_CODE, PRICE, SEARCH