1
Answer

Have anyone ever created a voice conference room?

Vince Peterson

Vince Peterson

12y
1.2k
1
I intend to create a voice conference room for making conference calls, but I don't have much experience with it. On a forum I got this link: http://www.voip-sip-sdk.com/p_155-voip-voice-conference-room-voip.html
It seems fair, but I would like to extend my knowledge with some extra ideas from you, fellow developers. Can you help me?
Answers (1)
0
Marcel Hertel

Marcel Hertel

NA 54 0 14y
hi,

assume that you have the columns emp_id and emp_name in your emp-table you can use the following procedure:

create procedure sp_Sortdata
(
    @Orderbyclause varchar(50)
)
as
select
    *
from
    emp e
order by   
    case when @Orderbyclause = 'emp_id' then e.emp_id end asc
    ,case when @Orderbyclause = 'emp_name' then e.emp_name end asc
   
if you execute exec sp_Sortdata 'emp_id' the procedure returns the emp-table ordered by emp_id

i hope this helps

Marcel Hertel