• DECLARE @year VARCHAR(4),

    @month TINYINT,

    @weekday TINYINT,

    @iOccAt TINYINT

    DECLARE @dt DATETIME

    SELECT @iOccAt = 5,@weekday =6,@month = 5,@year = 2014

    select@dt= DATEADD(MM,@month-1,DATEADD(YYYY,@year-1900,0))+

    CASE WHEN DATEPART(DW,DATEADD(MM,@month-1,DATEADD(YYYY,@year-1900,0))) > @weekday

    THEN 7-DATEPART(DW,DATEADD(MM,@month-1,DATEADD(YYYY,@year-1900,0)))+@weekday

    ELSE @weekday - (DATEPART(DW,DATEADD(MM,@month-1,DATEADD(YYYY,@year-1900,0)))) END + (7*(@iOccAt-1))

    select @dt, DATENAME(Dw,@dt)

    Regards,
    Mitesh OSwal
    +918698619998