USP_STUDENT_GETSTUDENTSELECTION

create procedure dbo.USP_STUDENT_GETSTUDENTSELECTION
(
    @TRANSACTIONQUERY as uniqueidentifier
)
as
begin
    set nocount on;

    declare @SQLTOEXEC nvarchar(max);
    declare @DBOBJECTNAME nvarchar(128);
    declare @DBOBJECTTYPE smallint;

    select @DBOBJECTNAME = DBOBJECTNAME, @DBOBJECTTYPE = OBJECTTYPE 
        from dbo.IDSETREGISTER where ID = @TRANSACTIONQUERY;

    if @DBOBJECTTYPE = 1 
        set @DBOBJECTNAME = @DBOBJECTNAME + '()';
    else if @DBOBJECTTYPE = 2 
        set @DBOBJECTNAME = @DBOBJECTNAME + '(''' + convert(nvarchar(36), @TRANSACTIONQUERY) + ''')';

    set @SQLTOEXEC = 'select ID from dbo.' + @DBOBJECTNAME + ' as Q'

    exec sp_executesql @SQLTOEXEC;
end