I removed the parameter from the SP and executed the SP (declare local variable and assign value instead) and it ran fine. I got the results in about 7 minutes....

I ran this situation in three different servers. All of them running SQL 2K sp3, Win 2K.

I believe I am running into some kind of parameter sniffing issue. This SP...

Any thoughts! Reply please.

Just bounce SQL Server Agent.

I know the column names in advance.

I kind of made it working. Here is the query:

--TEMP TABLE TO HOLD COLUMNS AS ROWS

CREATE TABLE #SECOND_TABLE

(REVIEWID VARCHAR(10) NULL,

FIELD_NAME VARCHAR(20) NULL,

FIELD_VALUE DATETIME...

If what you are saying is correct, this database cannot be huge. You have 4M users each holding 3KB data which brings to approximately 1.2GB database and add some space...

Thanks a lot for both replies.

Actually both replies helped me in different places. Thanks.

Depends on a variety of factors. First of all, how big is the query. For a big query, maintenance would be much easier if it is a SP than in...

The simplest way is to DTS the table to some other format like text file or excel file depending on the size.

Typically SQL Server backups are slightly smaller than

the actual database size - space available.

He might have logged in as Andrew at the time he created the tables Or he might have created the tables explicitly with owner name as Andrew.

Thanks Guys especially Nazim and SJC Systems.

Atlast I found it. The correct query is:

DELETE Base.dbo.na_log FROM Chg.dbo.na_log a, Base.dbo.na_log b

WHERE

a.Update_Type = 1 and

a.Update_Type = b.Update_type and

a.na_inst_nbr =...

Thanks Nazim. Thanks for your input.

The Select statement returns 34 rows. 24 rows with Update_type = 1 and 10 rows with Update_type = 2. These are the exact rows which...

The inner Join produces the same results. It deletes 34 rows. Similarly Right Outer Join produces the same results.

What i need is to delete only 24 rows (only rows with...

The query works but it will not work for my business logic. I cannot put a.Update_type = b.update_type in the condition.

quote:

---

Thanks...