USP_USERSETTINGSBATCHTEMPLATE_GETBYBATCHID

create procedure dbo.USP_USERSETTINGSBATCHTEMPLATE_GETBYBATCHID
(
  @APPUSERID uniqueidentifier,
    @BATCHID uniqueidentifier
)
as
begin
    select SETTINGS 
  from dbo.USERSETTINGSBATCHTEMPLATE
  inner join dbo.BATCH on USERSETTINGSBATCHTEMPLATE.BATCHTEMPLATEID = BATCH.BATCHTEMPLATEID
    where USERSETTINGSBATCHTEMPLATE.APPUSERID = @APPUSERID and BATCH.ID = @BATCHID;
end