Sorry..if you have misunderstood me...

I wanted just the syntax for that...thats it.

Anyways, thanks for your advice..

Can anyone of you...give me a syntax for creating Dynamic Table..??

Hi John Mitchell,

Due to performance issue, we are replacing all the temporary tables (# tables) with Permanent tables.

And, we need to execute the procedure simultaneously for different parameters. While doing...

Herewith sending the structure...

---------------------------------

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FSA_EXPORT_TEMP]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[FSA_EXPORT_TEMP]

GO

CREATE TABLE [dbo].[FSA_EXPORT_TEMP] (

[sp_id] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL ,

[id]...

While trying..I got this error..

Server: Msg 1069, Level 15, State 1, Procedure proc_fsa_export_usg_valuation, Line 329

Index hints are only allowed in a FROM clause.

please help...

Regards,

E Ezhilan

Thanks for your reply..

Actually..that procedure contains more than 20 called procedures (sub-procedure) which in turn will call some other procedures. So it is not possible to share the entire code.

Entire...

Thanks...its working fine..

Thanks...to everyone..

We have finally implemented the CASE logic and it is working fine.

This is the version..we are using..

Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)

May 3 2005 23:18:38

Copyright (c) 1988-2003 Microsoft Corporation

Enterprise Edition on Windows NT 5.2 (Build...

Hi.

We are not using..any DDL statments in this procedure. This is 14000 Line procedure which have lots of updates and inserts.

As I dont have Admin rights, I cant perform checkdb,...

Thanks...

It was really usefull..

Kindest Regards,

Ezhilan

Hi Jelf Moden,

Thankyou very much for your inputs. It was really useful.

BTW...can you please tell me, how can I find out which procedure is doing it and line numbers which cause...

Hi Sugesh,

How about using this at the beginning of the procedure...

SET TRANSACTION ISOLATION LEVEL

    { READ COMMITTED

        | READ UNCOMMITTED

        | REPEATABLE READ

        | SERIALIZABLE

   ...

Hi,

Can you please send the script for this..

Thnx,

Ezhilan