Samuele E. Locatelli
22 lines
447 B
SQL
22 lines
447 B
SQL
-- =============================================
|
|
-- Author: Steamware
|
|
-- Create date: 2014.02.23
|
|
-- Description: recupera riga QRM
|
|
-- =============================================
|
|
create PROCEDURE dbo.stp_QRM_getByKey
|
|
(
|
|
@QuoteType CHAR(1) = 'Q'
|
|
,@CodQuote BIGINT = 0
|
|
,@QuoteRev INT = 0
|
|
,@NumRM INT = 0
|
|
)
|
|
AS
|
|
|
|
SELECT *
|
|
FROM QuoteRM
|
|
WHERE QuoteType = @QuoteType
|
|
AND CodQuote = @CodQuote
|
|
AND QuoteRev = @QuoteRev
|
|
AND NumRM = @NumRM
|
|
|
|
RETURN |