Samuele E. Locatelli
16 lines
473 B
Transact-SQL
16 lines
473 B
Transact-SQL
|
|
-- =============================================
|
|
-- Author: Steamware
|
|
-- Mod. date: 2014.05.27
|
|
-- Description: conteggio StandardCostList ancora da processare
|
|
-- =============================================
|
|
CREATE PROCEDURE [dbo].[stp_SC2C_countRemaining]
|
|
AS
|
|
|
|
DECLARE @Date AS SMALLDATETIME = CONVERT(SMALLDATETIME,CONVERT(CHAR(8), GETDATE(), 112))
|
|
|
|
SELECT COUNT(*) as RecordsIn
|
|
FROM dbo.CostList
|
|
WHERE DateList = @Date AND QuoteType = 'C' AND CodQuote = 0
|
|
|
|
RETURN |