how to write stored procedure
in the situation if business table have column like empid int, custtype varchar,dealertype varchar,photographertype varchar, sal int,
employee belong either custtype or dealertype or photographertype
i want show the result as if
empid
|
custtype
|
dealertype
|
photographertype
|
sal
|
1
|
|
d
|
|
1000
|
2
|
c
|
|
|
2000
|
if i fetch the data from business table my out put should as