Declare @Mth int
Set @Mth = Datepart(Month, getdate())
IF @Mth in (10, 11, 12, 1, 2, 3)
print 'do your stuff'
print 'skip process'
Open in new window
DECLARE @M AS DATE
SET @M = GETDATE()
DECLARE @Month AS VARCHAR(3)
SET @Month = LEFT(DATENAME(MONTH, GETDATE()),3)
IF @Month = 'Oct' or @Month = 'Nov' or @Month = 'Dec' or @Month = 'Jan' or @Month = 'Feb' or @Month = 'Mar'
ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.
One of a set of tools we're offering as a way to say thank you for being a part of the community.
If the function is driven by getdate ()
details of the udf....
Be seen. Boost your question’s priority for more expert views and faster solutions