> 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?
My knowledge with computed columns is kind of limited. I know that I can do
something like this:('REQ_ID-' + convert(varchar,[id_col])) where the [id_col]
is a date in this format (YYYYMMDD). The part which I'm missing, actually
two,is how to convert the date to this format (20070224) and how to increment
the last 2 digits (i.e. 01, 02)?
Any help is appreciated.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create Web Applications With ColdFusion MX7 & Flex 2.
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/
Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2749
Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
