Simple Block

DECLARE

@YEAR VARCHAR(MAX);

Begin

set @YEAR='Aug-2011';

SELECT COUNT (*) ,@year ,'Test'

End

Search Column name from all tables.

 SELECT DISTINCT TABLE_NAME , COLUMN_NAME
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE COLUMN_NAME like '%semester%'