This is a simple way for development but performance wise it will costa lot for your application.įETCH NEXT FROM Cur_Cursor INTO as Insert into tbl_Currency Values ('British pound') Insert into tbl_Currency Values ('UAE dirham') Insert into tbl_Currency Values ('Philippine peso') Insert into tbl_Currency Values ('Pakistani rupee') Insert into tbl_Currency Values ('Indian rupee') Insert into tbl_Currency Values ('European euro') Insert into tbl_Currency Values ('US dollar') Let me create a simple example to explain these methods in detail. Lets say I have multiple currencies in a table and I would like to display in a single comma separated rows. I was preparing a statistical report and was stuck in one place where I needed to convert certain rows to comma separated values and put into a single row.
0 Comments
Leave a Reply. |