Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
noblemfd
Starting Member
38 Posts |
 Posted - 2012-02-07 : 17:07:32
|
| I WANT TO USE MSSQL 2000 USER-DEFINED FUNCTION TO ACHIEVE THE GOAL BELOW. PLEASE HELP ME OUR, OR IS THERE ANY OTHER METHOD USING MSSQL 2000.I HAVE A TABLE CALLED INVOICE WITH FOUR FIELDS NAMELY INVNUM, RECEIPTNUM, DATE, AMOUNT. PRESENT STATEINVNUM--> RECEIPTNUM--> DATE--> AMOUNT1 -->000001/000002 -->11/02/2010 -->12,222.00/32,234.0023 -->000003--> 21/09/2011--> 32,345.00EXPECTED RESULTINVNUM--> RECEIPTNUM--> DATE--> AMOUNT1--> 000001--> 11/02/2010 -->12,222.001 -->000002--> 11/02/2010-- 32,234.0023 -->000003 -->21/09/2011 -->32,345.00Please kindly assist. Or do you know how I can use MSSQL FUNCTION to resolve it? I need it urgently.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
FUNCTION