Wednesday, April 8, 2009

Do not run stored procedure if file does exist using sysobjects

if not exists (SELECT * FROM Warehouse..sysobjects WHERE name = 'sales' and convert(varchar, crdate, 102) = CONVERT(varchar, GETDATE(), 102)) goto ExitHere

No comments: