> Perhaps if you explain what it is that you're actually trying to acomplish we
> can provide you with a solution that doesn't need dynamically created tables
> with dynamically added columns at all.
>
>
> ML
>
> ---
> http://milambda.blogspot.com/

> DECLARE @SID Varchar(10)
> SET @SID = '00260AMIT'
> DECLARE @STR VARCHAR(1000)
> SET @STR = ''
>
>  SET @STR = 'CREATE TABLE RD_'+ @SID +' (RESPID INT PRIMARY KEY, FLAG
> BIT)'
>  EXEC(@STR)
>
>   DECLARE @FIELDCODE INT, @FIELDNAME VARCHAR(20)
>  SET @STR = 'DECLARE CURTABLECREATION CURSOR LOCAL STATIC FORWARD_ONLY
>  FOR
>  SELECT DISTINCT CODE, DESCRIPT FROM UI_'+ @SID +' ORDER BY CODE
>  OPEN CURTABLECREATION
>  FETCH NEXT FROM CURTABLECREATION INTO @FIELDCODE, @FIELDNAME
>  WHILE @@FETCH_STATUS = 0
>  BEGIN
>   SET @STR = ''ALTER TABLE RD_'+ @SurveyID +' ADD ' + @FIELDNAME + '
> TINYINT''
>   EXEC(@STR)
>   FETCH NEXT FROM CURTABLECREATION INTO @FIELDCODE, @FIELDNAME
>  END
>  CLOSE CURTABLECREATION
>  DEALLOCATE CURTABLECREATION'
>
>
> I want to run this cursor. This is based on the table UI_00260AMIT and
> rd_00260AMIT. These tables are created just before this step. In fact
> you can see the code of RD_00260AMIT creation. Now my questions is how
> do I run a cursor that is based on the table that created dynamically.
>
> please suggest.

> amit wrote:
> > DECLARE @SID Varchar(10)
> > SET @SID = '00260AMIT'
> > DECLARE @STR VARCHAR(1000)
> > SET @STR = ''
> >
> >  SET @STR = 'CREATE TABLE RD_'+ @SID +' (RESPID INT PRIMARY KEY, FLAG
> > BIT)'
> >  EXEC(@STR)
> >
> >   DECLARE @FIELDCODE INT, @FIELDNAME VARCHAR(20)
> >  SET @STR = 'DECLARE CURTABLECREATION CURSOR LOCAL STATIC FORWARD_ONLY
> >  FOR
> >  SELECT DISTINCT CODE, DESCRIPT FROM UI_'+ @SID +' ORDER BY CODE
> >  OPEN CURTABLECREATION
> >  FETCH NEXT FROM CURTABLECREATION INTO @FIELDCODE, @FIELDNAME
> >  WHILE @@FETCH_STATUS = 0
> >  BEGIN
> >   SET @STR = ''ALTER TABLE RD_'+ @SurveyID +' ADD ' + @FIELDNAME + '
> > TINYINT''
> >   EXEC(@STR)
> >   FETCH NEXT FROM CURTABLECREATION INTO @FIELDCODE, @FIELDNAME
> >  END
> >  CLOSE CURTABLECREATION
> >  DEALLOCATE CURTABLECREATION'
> >
> >
> > I want to run this cursor. This is based on the table UI_00260AMIT and
> > rd_00260AMIT. These tables are created just before this step. In fact
> > you can see the code of RD_00260AMIT creation. Now my questions is how
> > do I run a cursor that is based on the table that created dynamically.
> >
> > please suggest.
>
> My suggestion is that you scrap the whole idea and think again. Your
> proposed scheme is unsound and highly impractical.
>
> Possibly someone here could offer some advice if you explain more about
> the application. Unfortunately it's very hard and often unwise to give
> detailed design advice online. The limited information we can exchange
> in an online conversation makes it much easier for us to criticize a
> bad solution than to design good one. If you don't have a lot of
> experience at database design then you should consider hiring some
> expertise to help out with your project.
>
> --
> David Portas, SQL Server MVP
>
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
>
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --

> David,
>
> Thanks for your advice. I have already done this.
> Actually here I have to run an application on a global user account.
> and i have written some code that creates some tables, but if i run
> this with a single user account then my tables get overwritten by one
> another coz this application will run by more then one user
> simultaneously. So for this purpose i have to write the script in such
> format that it creates unique tables and perform the execution
> successfully. coz first i have upload data from excel then run sp to
> perform my logic and expost the final data in excel format.

> I think by this you can understand why did i choose this method of
> creating tables runtime.