Procedure

ALTER PROCEDURE Uams.AMS_UpdateAssetRequestFromDraft(@DraftAssetIds varchar(max))
As
Begin
    declare @Query nvarchar(max)
    set @Query='update Uams.AMS_RequisitionDraftAsset set Status=''Draft'' where Draft_Asset_ID in('+@DraftAssetIds+')'
    exec( @Query)
End
ALTER PROCEDURE [dbo].[p]
(
@mark varchar(max)
)
AS  
begin
declare @x varchar(max)
declare @y varchar(max)
set @x=(select mark from emp3 where id=4)
SET @Y='select * from emp3 where id1 in('+@x+')'
exec(@y)
end