using System;

public class Program

{

    public static void Main()

    {

        Console.WriteLine("Hello World");

        /*GO

SET QUOTED_IDENTIFIER ON

GO

CREATE OR ALTER PROCEDURE [dbo].[GetChildBloombergDataGrid]  

AS  

BEGIN  

    SELECT

        ct.ChildTickerId,

        c.EffectiveDate,

        ct.ParentTickerId,

        c.AccurateRate,

        c.RoundedRate,

        ct.TickerName,

        tc.Name,

        tc.Ticker,

        tc.ApplyFormula,

        c.EqnMessageId

    FROM 

        admin.ChildTickerConfig ct

    INNER JOIN (

        SELECT

            ChildTickerId,

            ParentTickerId,

            MAX(EodDate) AS EffectiveDate

        FROM 

            bloomberg.ChildBloombergDataInput

        GROUP BY

            ChildTickerId,

            ParentTickerId

    ) AS cMaxDate ON ct.ChildTickerId = cMaxDate.ChildTickerId AND ct.ParentTickerId = cMaxDate.ParentTickerId

    INNER JOIN 

        bloomberg.ChildBloombergDataInput c ON ct.ChildTickerId = c.ChildTickerId AND ct.ParentTickerId = c.ParentTickerId AND c.EodDate = cMaxDate.EffectiveDate

    INNER JOIN 

        admin.TickerConfig tc ON tc.TickerId = ct.ParentTickerId;

END

​

*/

    }

}