Ricardo,
Take a look at Message#
954973<>I've got the follow UDF to get the next invoice number in a VFP table called DocsNumbers.
>
>LOCAL lnNext
>
>SET MULTILOCKS ON
>SET REPROCESS TO 0 Automatic
>
>SELECT DocsNumbers
>WAIT WINDOW "Gettign document number..." NOWAIT
>RLOCK()
>lnNext = DocsNumbers.invoice +1
>REPLACE DocsNumbers.invoice WITH lnNext
>TABLEUPDATE(.T.)
>UNLOCK IN DocsNumbers
>WAIT CLEAR
>
>RETURN lnNext
>
>
>How can I do this in T-SQL using a SQL server database ?
>
>T.I.A.
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst