ALTER PROCEDURE [dbo].[InsertStudentDetails]
@valueList varchar(8000),
@Username NVarChar(55)

set @len = CHARINDEX(',', @valueList, @pos+1) - @pos
set @value = SUBSTRING(@valueList, @pos, @len)

     if isnumeric(@value)=0
     begin
        set @Table_Name =  @value


     end

     if isnumeric(@value)=1
     begin
        set @list=  @list + @Table_Name + '-' + @value + '-'  + '*'  + '-        end

    if left(@Table_Name,1)='P'  and isnumeric(@value)=1
    begin

        **set @subject_name='RNSNEETJEEPhysics.dbo.'+   @Table_Name

        SELECT  @ans =ans FROM **[ ' + @subject_name + ']** WHERE id = @value**

        set @list=  @list + @ans + '-'


    end



  set @pos = CHARINDEX(',', @valueList, @pos+@len) +1

End