C# Online Compiler | .NET Fiddle

<no name> by Anonymous

using System;
					
public class Program
{
	public static void Main()
	{
		string[] listofcolumns = {"Match_Type","StartFlag","StartTerm2Flag","MORTGAGE_PURCHASE_INDICATOR","LIV_MOSAIC_ZIP4","LIV_POCN_0_3","PERETHNICCODE","PERS_ET_RELG_1","PERGENDER","OCCUPATION_MODEL","Is_Organic_Lead","amPrevEducId","amLeadCatId_SSID2","amLeadCatId_SSID3","LeadCategory_Internet","HOUSEHOLDER_AGE_25_34","CNSMR_WRST_PRSNT_STAT_TRD_LS_6_MTH","POP_WHITE","GENDER_POP_FEMALE","IND_TRANSPORT_WAREHOUSING_catg","IND_WHOLESALE_TRADE_catg","OCCUPATION_HLTHCARE_SUPP_catg","OCCUPATION_OFFICE_ADMIN_catg","URBAN_POP_CLUSTERS","LIVULENGTHRESIDENCE_BINS","COUNT_OWNER_OCCUPIED_HOUSING_UNITS","AVG_BANKRUPTCY_TRD","AVG_TRD_MAX_DLINQ_120_180_D_LS_24_MTH","AVG_RVLV_BNKCD_TRD_BAL_TO_CR_ABV_100","AVG_PERSONAL_FINANCE_TRD_60_D_DRGTRY","AVG_HOME_EQ_TRD_30_D_DELINQ","AVG_OPN_PRCNT_INSTLMT_TRD_LS_6_MTH","AVG_CR_PERSONAL_FINANCE_INQURIES","AVG_MRGG_TRD_30_D_DLINQ_LS_6_MTH","AVG_MRGG_TRD_90_D_DRGTRY","AVG_BAL_TO_CR_RVLV_TRD_LS_6_MTH","AVG_MTH_FRM_RVLV_TRD_OPENED","PSCS_STU1100_AVG","AVG_UTILITY_TRD","HISP_VS_N_HISP_SCORE","HIGH_VS_LOW_AFFLUENCE_SCORE","LIVUADDRDUSIZE","GEO_CNTYSIZE","IS_AGE_EXACT","PERCOMBINEDAGE_BINS","Email_domain","LeadRecv_on_Weekend","LeadRecv_on_MonTue","LeadRecv_on_WedThursFri","Season","timepart","GeoRegion","PreviouslyseenTotalLeadCount_catg","PrevSeen_LessThan365Days_catg","PrevSeen_365_730Days_catg","PrevSeen_Over730Days_catg","CrossCampus_PreviouslySeenTotalLeadCount_catg","CrossCampus_PrevSeenLead_LessThan365DaysCount_catg","CrossCampus_PrevSeenLead_365_730DaysCount_catg","CrossCampus_PrevSeenLead_Over730DaysCount_catg","StartCount_vs_creditsEarned","ApplicationCount_vs_creditsEarned","CrossCampus_StartCount_vs_creditsEarned","CrossCampus_ApplicationCount_vs_creditsEarned"};
		foreach (string col in listofcolumns)
        {
            // Step 3: access the enumeration variable.
            Console.WriteLine("select " + col + ",count("+col+") as Total FROM `cec-gcp-lsp.final_prospect_data.final_exhaustive_dataset` group by " + col + " order by count(" + col + ") desc;" );
			
			 //Console.WriteLine("select " + col + ",count("+col+") as Total FROM `cec-gcp-lsp.final_prospect_data.final_exhaustive_dataset` group by " + col + " order by count(" + col + ") desc;" );
        }
		Console.WriteLine("------------------------------------------------------------------------------------------");
		Console.WriteLine("---------PEC Database------------------");
		Console.WriteLine("------------------------------------------------------------------------------------------");
		foreach (string col in listofcolumns)
        {
            // Step 3: access the enumeration variable.
            //Console.WriteLine("select " + col + ",count("+col+") as Total FROM `cec-gcp-lsp.final_prospect_data.final_exhaustive_dataset` group by " + col + " order by count(" + col + ") desc;" );
			Console.WriteLine("Select 'Getting Unique Columns for:  " + col + "';");
			 Console.WriteLine("select " + col + ",count("+col+") as Total FROM [OEGIntranet].[dbo].[PEC_Experian_final_dataset_050120] group by " + col + " order by count(" + col + ") desc;" );
        }
	}
}

 
using System;
                    
public class Program
{
    public static void Main()
    {
        string[] listofcolumns = {"Match_Type","StartFlag","StartTerm2Flag","MORTGAGE_PURCHASE_INDICATOR","LIV_MOSAIC_ZIP4","LIV_POCN_0_3","PERETHNICCODE","PERS_ET_RELG_1","PERGENDER","OCCUPATION_MODEL","Is_Organic_Lead","amPrevEducId","amLeadCatId_SSID2","amLeadCatId_SSID3","LeadCategory_Internet","HOUSEHOLDER_AGE_25_34","CNSMR_WRST_PRSNT_STAT_TRD_LS_6_MTH","POP_WHITE","GENDER_POP_FEMALE","IND_TRANSPORT_WAREHOUSING_catg","IND_WHOLESALE_TRADE_catg","OCCUPATION_HLTHCARE_SUPP_catg","OCCUPATION_OFFICE_ADMIN_catg","URBAN_POP_CLUSTERS","LIVULENGTHRESIDENCE_BINS","COUNT_OWNER_OCCUPIED_HOUSING_UNITS","AVG_BANKRUPTCY_TRD","AVG_TRD_MAX_DLINQ_120_180_D_LS_24_MTH","AVG_RVLV_BNKCD_TRD_BAL_TO_CR_ABV_100","AVG_PERSONAL_FINANCE_TRD_60_D_DRGTRY","AVG_HOME_EQ_TRD_30_D_DELINQ","AVG_OPN_PRCNT_INSTLMT_TRD_LS_6_MTH","AVG_CR_PERSONAL_FINANCE_INQURIES","AVG_MRGG_TRD_30_D_DLINQ_LS_6_MTH","AVG_MRGG_TRD_90_D_DRGTRY","AVG_BAL_TO_CR_RVLV_TRD_LS_6_MTH","AVG_MTH_FRM_RVLV_TRD_OPENED","PSCS_STU1100_AVG","AVG_UTILITY_TRD","HISP_VS_N_HISP_SCORE","HIGH_VS_LOW_AFFLUENCE_SCORE","LIVUADDRDUSIZE","GEO_CNTYSIZE","IS_AGE_EXACT","PERCOMBINEDAGE_BINS","Email_domain","LeadRecv_on_Weekend","LeadRecv_on_MonTue","LeadRecv_on_WedThursFri","Season","timepart","GeoRegion","PreviouslyseenTotalLeadCount_catg","PrevSeen_LessThan365Days_catg","PrevSeen_365_730Days_catg","PrevSeen_Over730Days_catg","CrossCampus_PreviouslySeenTotalLeadCount_catg","CrossCampus_PrevSeenLead_LessThan365DaysCount_catg","CrossCampus_PrevSeenLead_365_730DaysCount_catg","CrossCampus_PrevSeenLead_Over730DaysCount_catg","StartCount_vs_creditsEarned","ApplicationCount_vs_creditsEarned","CrossCampus_StartCount_vs_creditsEarned","CrossCampus_ApplicationCount_vs_creditsEarned"};
        foreach (string col in listofcolumns)
        {
            // Step 3: access the enumeration variable.
            Console.WriteLine("select " + col + ",count("+col+") as Total FROM `cec-gcp-lsp.final_prospect_data.final_exhaustive_dataset` group by " + col + " order by count(" + col + ") desc;" );
            
             //Console.WriteLine("select " + col + ",count("+col+") as Total FROM `cec-gcp-lsp.final_prospect_data.final_exhaustive_dataset` group by " + col + " order by count(" + col + ") desc;" );
        }
        Console.WriteLine("------------------------------------------------------------------------------------------");
        Console.WriteLine("---------PEC Database------------------");
        Console.WriteLine("------------------------------------------------------------------------------------------");
        foreach (string col in listofcolumns)
        {
            // Step 3: access the enumeration variable.
            //Console.WriteLine("select " + col + ",count("+col+") as Total FROM `cec-gcp-lsp.final_prospect_data.final_exhaustive_dataset` group by " + col + " order by count(" + col + ") desc;" );
            Console.WriteLine("Select 'Getting Unique Columns for:  " + col + "';");
             Console.WriteLine("select " + col + ",count("+col+") as Total FROM [OEGIntranet].[dbo].[PEC_Experian_final_dataset_050120] group by " + col + " order by count(" + col + ") desc;" );
        }
    }
}

Key: `
  Value: 1!

Key: ~
  Value: 1!

Key: 1
  Value: qQ
  Value: 2@
  Value: `~

Key: !
  Value: qQ
  Value: 2@
  Value: `~

Key: 2
  Value: wW
  Value: 3#
  Value: 1!
  Value: qQ

Key: @
  Value: wW
  Value: 3#
  Value: 1!
  Value: qQ

Key: 3
  Value: eE
  Value: 4$
  Value: 2@
  Value: wW

Key: #
  Value: eE
  Value: 4$
  Value: 2@
  Value: wW

Key: 4
  Value: rR
  Value: 5%
  Value: 3#
  Value: eE

Key: $
  Value: rR
  Value: 5%
  Value: 3#
  Value: eE

Key: 5
  Value: tT
  Value: 6^
  Value: 4$
  Value: rR

Key: %
  Value: tT
  Value: 6^
  Value: 4$
  Value: rR

Key: 6
  Value: yY
  Value: 7&
  Value: 5%
  Value: tT

Key: ^
  Value: yY
  Value: 7&
  Value: 5%
  Value: tT

Key: 7
  Value: uU
  Value: 8*
  Value: 6^
  Value: yY

Key: &
  Value: uU
  Value: 8*
  Value: 6^
  Value: yY

Key: 8
  Value: iI
  Value: 9(
  Value: 7&
  Value: uU

Key: *
  Value: iI
  Value: 9(
  Value: 7&
  Value: uU

Key: 9
  Value: oO
  Value: 0)
  Value: 8*
  Value: iI

Key: (
  Value: oO
  Value: 0)
  Value: 8*
  Value: iI

Key: 0
  Value: pP
  Value: -_
  Value: 9(
  Value: oO

Key: )
  Value: pP
  Value: -_
  Value: 9(
  Value: oO

Key: -
  Value: [{
  Value: =+
  Value: 0)
  Value: pP

Key: _
  Value: [{
  Value: =+
  Value: 0)
  Value: pP

Key: =
  Value: ]}
  Value: -_
  Value: [{

Key: +
  Value: ]}
  Value: -_
  Value: [{

Key: q
  Value: aA
  Value: wW
  Value: 2@
  Value: 1!

Key: Q
  Value: aA
  Value: wW
  Value: 2@
  Value: 1!

Key: w
  Value: sS
  Value: eE
  Value: 3#
  Value: 2@
  Value: qQ
  Value: aA

Key: W
  Value: sS
  Value: eE
  Value: 3#
  Value: 2@
  Value: qQ
  Value: aA

Key: e
  Value: dD
  Value: rR
  Value: 4$
  Value: 3#
  Value: wW
  Value: sS

Key: E
  Value: dD
  Value: rR
  Value: 4$
  Value: 3#
  Value: wW
  Value: sS

Key: r
  Value: fF
  Value: tT
  Value: 5%
  Value: 4$
  Value: eE
  Value: dD

Key: R
  Value: fF
  Value: tT
  Value: 5%
  Value: 4$
  Value: eE
  Value: dD

Key: t
  Value: gG
  Value: yY
  Value: 6^
  Value: 5%
  Value: rR
  Value: fF

Key: T
  Value: gG
  Value: yY
  Value: 6^
  Value: 5%
  Value: rR
  Value: fF

Key: y
  Value: hH
  Value: uU
  Value: 7&
  Value: 6^
  Value: tT
  Value: gG

Key: Y
  Value: hH
  Value: uU
  Value: 7&
  Value: 6^
  Value: tT
  Value: gG

Key: u
  Value: jJ
  Value: iI
  Value: 8*
  Value: 7&
  Value: yY
  Value: hH

Key: U
  Value: jJ
  Value: iI
  Value: 8*
  Value: 7&
  Value: yY
  Value: hH

Key: i
  Value: kK
  Value: oO
  Value: 9(
  Value: 8*
  Value: uU
  Value: jJ

Key: I
  Value: kK
  Value: oO
  Value: 9(
  Value: 8*
  Value: uU
  Value: jJ

Key: o
  Value: lL
  Value: pP
  Value: 0)
  Value: 9(
  Value: iI
  Value: kK

Key: O
  Value: lL
  Value: pP
  Value: 0)
  Value: 9(
  Value: iI
  Value: kK

Key: p
  Value: ;:
  Value: [{
  Value: -_
  Value: 0)
  Value: oO
  Value: lL

Key: P
  Value: ;:
  Value: [{
  Value: -_
  Value: 0)
  Value: oO
  Value: lL

Key: [
  Value: '"
  Value: ]}
  Value: =+
  Value: -_
  Value: pP
  Value: ;:

Key: {
  Value: '"
  Value: ]}
  Value: =+
  Value: -_
  Value: pP
  Value: ;:

Key: ]
  Value: \|
  Value: =+
  Value: [{
  Value: '"

Key: }
  Value: \|
  Value: =+
  Value: [{
  Value: '"

Key: \
  Value: ]}

Key: |
  Value: ]}

Key: a
  Value: zZ
  Value: sS
  Value: wW
  Value: qQ

Key: A
  Value: zZ
  Value: sS
  Value: wW
  Value: qQ

Key: s
  Value: xX
  Value: dD
  Value: eE
  Value: wW
  Value: aA
  Value: zZ

Key: S
  Value: xX
  Value: dD
  Value: eE
  Value: wW
  Value: aA
  Value: zZ

Key: d
  Value: cC
  Value: fF
  Value: rR
  Value: eE
  Value: sS
  Value: xX

Key: D
  Value: cC
  Value: fF
  Value: rR
  Value: eE
  Value: sS
  Value: xX

Key: f
  Value: vV
  Value: gG
  Value: tT
  Value: rR
  Value: dD
  Value: cC

Key: F
  Value: vV
  Value: gG
  Value: tT
  Value: rR
  Value: dD
  Value: cC

Key: g
  Value: bB
  Value: hH
  Value: yY
  Value: tT
  Value: fF
  Value: vV

Key: G
  Value: bB
  Value: hH
  Value: yY
  Value: tT
  Value: fF
  Value: vV

Key: h
  Value: nN
  Value: jJ
  Value: uU
  Value: yY
  Value: gG
  Value: bB

Key: H
  Value: nN
  Value: jJ
  Value: uU
  Value: yY
  Value: gG
  Value: bB

Key: j
  Value: mM
  Value: kK
  Value: iI
  Value: uU
  Value: hH
  Value: nN

Key: J
  Value: mM
  Value: kK
  Value: iI
  Value: uU
  Value: hH
  Value: nN

Key: k
  Value: ,<
  Value: lL
  Value: oO
  Value: iI
  Value: jJ
  Value: mM

Key: K
  Value: ,<
  Value: lL
  Value: oO
  Value: iI
  Value: jJ
  Value: mM

Key: l
  Value: .>
  Value: ;:
  Value: pP
  Value: oO
  Value: kK
  Value: ,<

Key: L
  Value: .>
  Value: ;:
  Value: pP
  Value: oO
  Value: kK
  Value: ,<

Key: ;
  Value: /?
  Value: '"
  Value: [{
  Value: pP
  Value: lL
  Value: .>

Key: :
  Value: /?
  Value: '"
  Value: [{
  Value: pP
  Value: lL
  Value: .>

Key: '
  Value: ]}
  Value: [{
  Value: ;:
  Value: /?

Key: "
  Value: ]}
  Value: [{
  Value: ;:
  Value: /?

Key: z
  Value: xX
  Value: sS
  Value: aA

Key: Z
  Value: xX
  Value: sS
  Value: aA

Key: x
  Value: cC
  Value: dD
  Value: sS
  Value: zZ

Key: X
  Value: cC
  Value: dD
  Value: sS
  Value: zZ

Key: c
  Value: vV
  Value: fF
  Value: dD
  Value: xX

Key: C
  Value: vV
  Value: fF
  Value: dD
  Value: xX

Key: v
  Value: bB
  Value: gG
  Value: fF
  Value: cC

Key: V
  Value: bB
  Value: gG
  Value: fF
  Value: cC

Key: b
  Value: nN
  Value: hH
  Value: gG
  Value: vV

Key: B
  Value: nN
  Value: hH
  Value: gG
  Value: vV

Key: n
  Value: mM
  Value: jJ
  Value: hH
  Value: bB

Key: N
  Value: mM
  Value: jJ
  Value: hH
  Value: bB

Key: m
  Value: ,<
  Value: kK
  Value: jJ
  Value: nN

Key: M
  Value: ,<
  Value: kK
  Value: jJ
  Value: nN

Key: ,
  Value: .>
  Value: lL
  Value: kK
  Value: mM

Key: <
  Value: .>
  Value: lL
  Value: kK
  Value: mM

Key: .
  Value: /?
  Value: ;:
  Value: lL
  Value: ,<

Key: >
  Value: /?
  Value: ;:
  Value: lL
  Value: ,<

Key: /
  Value: '"
  Value: ;:
  Value: .>

Key: ?
  Value: '"
  Value: ;:
  Value: .>

Last Run:	12:40:54 pm
Compile:	0.025s
Execute:	0.1s
Memory:	5.54Mb
CPU:	0.125s

View IL Code