hi daniweb...
i need some help for my projects...maybe u all can help me....
i want to make a autonumber field in sqlserver and will be reset to 1 every 1st day in a new month....it will be use for document numbering..because i want to make the doc format is like 0910.0001 where 0910 is year and month and 0001 is and autonumber...and it will be reset to 0911.0001 at the new month....
thx for the attention....