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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-10 : 09:08:42
|
| Rajesh writes "I need to create a procedure which takes date as a parameterand spells it.eg: 1-4-2001 should give First April two thousand oneThe easiest way is the look up table technique whereinan array with contentsfirst,second,....,thirty is createdand after using day(getdate()),I can just retrive (day-1)thelement from the array.Unfortunately we dont have arrays in sql server & csv varchar approach that u suggested in earlier articles doesn't help me.Could anyone help me with this???Also the datename function spells just the month & the week-daysIt doesn't spell the year & the date.So it is only partially useful if i need to spell the complete date.Is there any inbuilt procedure which can help me with this???" |
|
|
|
|
|
Using Array in Stored Procedure