• Good Article Divya....

    This is Another way..

    set datefirst 2

    select datediff(dd,5,'12/17/2009')%7

    set datefirst 5

    select datediff(dd,5,'12/17/2009')%7