• Nakul,

    Nice article. One small problem I noticed was that the constraint for being 18 years old was given as:

    (DATEDIFF(YEAR,BirthDate,GETDATE()) >= 18);

    That won't give the correct answer when the birthdate is later in the year than the current date. Wouldn't it be better to use:

    (DATEADD(YEAR, -18,GETDATE()) >= BirthDate);

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn