I m found a way to get the first day of the year without hardcode in the stored procedure.
here the SQL script.
convert
(char(20), convert(char(4), year(getdate())) + ‘/01/01′, 111)
To test it, simply put “select” in front of the pink color script above.
The result, if your system current year is 2008, it will return 2008/1/1!
