I am wondering if this is possible.
I understand how to create a variable within my query - when I am assigning a value from a table query to the variable. However I am wondering is it possible to instead of pulling the value from a query to actually pull it from a stored procedure?
DECLARE @Payout Float
SELECT @Payout = SUM(revenue)
(EXEC [dbo].[mystoredprocedure] '2014-09-01','2014-10-01')SUBQ
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed