> I am building a job recruitment application using ASP/VB and MS SQL
> 2000. I would like use requisition number (REQ_ID) for each entry in
> the database and I want that number to increment for each given day.
> So the first REQ_ID for February 24, 2007 will be something like
> (REQ-20070224-01) and the next REQ_ID will be (REQ-20070224-01). Can
> this be
done?
I was able to resolve the first part by using a cmputed column ('REQ-' +
convert(varchar,[y],112)) as [y] being a date column. I still can not figure
out how to increment the (01, 02) issue.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/
Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2751
Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
