USE tempdb;

CREATE TABLE dbo.LogSistema(
id int NOT NULL IDENTITY PRIMARY KEY,
procedura varchar(100) NOT NULL, 
descrizione varchar(512) NOT NULL,
dataInizio datetime NOT NULL,
dataFine datetime NOT NULL,
[FileName] varchar(100)NOT NULL,
esito decimal(9) NOT NULL
);

INSERT dbo.LogSistema VALUES('DTS','Smart_Operator_Modificato','20080116','20080116','SO_EstrazioneUtentiModificati','1')
GO

CREATE PROCEDURE dbo.up_GetLogs(
@dataFine datetime
)
AS
SELECT *
FROM dbo.LogSistema
WHERE descrizione  = 'Smart_Operator_Modificato' 
AND dataFine <= @dataFine;
GO

EXEC dbo.up_GetLogs '20080116';

/* Output:

id          procedura
----------- ---------- ...
1           DTS

(1 row(s) affected)

*/

DROP PROCEDURE dbo.up_GetLogs;
DROP TABLE dbo.LogSistema;