Database

DECLARE @JoiningDate DATE
SET @JoiningDate = '10/10/2013'

IF (YEAR(GETDATE()) > YEAR(@JoiningDate))
    BEGIN
	IF (DAY(@JoiningDate) = DAY(GETDATE()) AND DAY(@JoiningDate) = DAY(GETDATE()))
	    BEGIN
                /*
                This will exceute on every year of joining date.
                Below is the print statement to check the testing result.                                
                */
	        PRINT CONVERT(NVARCHAR,(YEAR(GETDATE()) - YEAR(@JoiningDate))) + ' Year(s)'
	    END
    END

jugnu_ad wrote:

What could be the cause of this abnormal behavior?

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Tim Carmichael wrote:

While VB 6 may have it issues, I have written and used in production many applications written in VB 6 pulling data from SQL Server without issue.

Tim Carmichael wrote:

I suspect it is with the coding, not the underlying foundations.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

UPDATE MyTable SET Column1 = 'Value1' WHERE mycolumn = 10

UPDATE MyTable SET Column1 = 'Value1' WHERE mycolumn > 10

UPDATE MyTable SET Column1 = 'Value1' WHERE mycolumn BETWEEN 10 AND 12

UPDATE MyTable SET Column1 = 'Value1' WHERE mycolumn IN (10, 12, 15, 30)

A B
----
1 1
2 2

A B
----
2 2
3 3

UPDATE TableName SET ColumnB = ColumnA + 9

UPDATE tableName SET columnB = 9 + t2.RowNum  FROM tableName t1 INNER JOIN (
SELECT ROW_NUMBER() OVER (ORDER BY columnA) RowNum,columnA FROM tableName) t2 ON t1.columnA = t2.columnA