Cool !!!

That the sort of thing i need as it going into a Business Intelligence system where users have to query aginst dates.

However, your dates come out as the 2nd of each month, ????

i would expect my results to be ......

INSERT INTO PS_TestForOnline

VALUES(1,1,2012); 2012-01-01 00:00:00.000

INSERT INTO PS_TestForOnline

VALUES(1,2,2012); 2012-02-01 00:00:00.000

INSERT INTO PS_TestForOnline

VALUES(1,3,2012); 2012-03-01 00:00:00.000

Thanks in advance

PS: just out of interest, why the -1900??