Hai,

    How do I find if a column is exists in a temp table?
I am creating a temp table and adding columns using ALTER TABLE in a loop,
but when same column name arrives it shows error. Please anyone help me.

Thanks in advace

I'd have to ask 1) Why are you building the temp table this way, and 2) why would there be a duplicate column?

Where are you getting the list of columns from, and where are you building the temp table? I think if you provide a bit more information we might be able to help you a bit more.

thanks for the immediate response, actually I am creating the temp table in a stored procedure. This procedure is for find the factory production
report all weeks in a year, as the production is based on the orders,I am getting repeat weeks. I solved this problem by using this code

SELECT
                SYSCOLUMNS.NAME AS [Column Name]
                FROM SYSOBJECTS
                    INNER JOIN SYSCOLUMNS ON SYSOBJECTS.ID = SYSCOLUMNS.ID
                    INNER JOIN SYSTYPES ON SYSTYPES.XTYPE = SYSCOLUMNS.XTYPE
            WHERE
                (OBJECTPROPERTY(SYSOBJECTS.id, N'IsUserTable') = 0
                AND SYSCOLUMNS.NAME = @ColumnName
                AND SYSOBJECTS.NAME = '##tempWeeklyProduction')
            ORDER BY SYSOBJECTS.NAME

thanks