Here's my query:

This is my first statement:-

set @string1= 'select MAX(backup_set_id)

FROM ['+@server_name+'].msdb.dbo.backupset

WHERE database_name = '''+@db+''' AND type = ''D'''

Second Statement:-

exec sp_executesql @string1, N'@item nvarchar(15) OUTPUT', @output = @item OUTPUT

select @output

I want to capture @output and use it later in a join