Thanks for u'r reply. I will check and tell the result.

Thanks,

Mano Karnan

Hi all,

We are having only one Job running on this. Also, we are taking the data from another server (SQL 2000) and the Package & jobs run...

Thanks for all your replies.

Thanks,

ManoKarnan

I want to use the mixed server query. That is

Select * From server1.DB1.dbo.Table1 a , server2.DB2.dbo.Table2 b

Where  a. no = b.no

something like the above. The query may be too long to...

I want to use the mixed server query. That is

Select * From server1.DB1.dbo.Table1 a , server2.DB2.dbo.Table2 b

Where  a. no = b.no

something like the above. The query may be too long to...

 Hai,

   My situation is that, i am trying to write a dynamic form of stored procedures for each tables in a database. i.e  If one table is created in DB means...

Hai,

  The table which i given is just an example in my real time scenario there may be thousands of records. In such cases this case statement is not comfortable to...

 Hai,

 I need to see the data in the format within query analyzer. I need a Query for that.

Thanks,

ManoKarnan 

hi,

 Can you please give me a simple example for using temporary tables instead of cursors.

Regards,

Manokarnan

 Thanks for all you replies. It's not a single time query i want to use this concept inside the stored procedure.

ManoKarnan

 Thanks for your replies.

I have a proper link between two tables. I want to delete a common record in both tables in a single delete statement.

Thank You very much for all u'r replies.

 Thank You Allen.

  Is there any other important points to be considered at the time of giving field names?