As i said earlier,

Politely saying, Since i visited our site more no of times(1370 visits from the joining date) and scored 1385 (comparing me with my related named persons...

As i said earlier,

Politely saying, Since i visited our site more no of times(1370 visits from the joining date) and scored 1385 (comparing me with my related named persons...

"alter procedure" is not supported in ASE. Your link points to ASA not ASE.

Take a look at the below URL.

http://www.tek-tips.com/viewthread.cfm?qid=1022421&page=13

RBarryYoung,

Thank you so much! I will try and get back to you.

Just disable the trigger and run more than one time. Look at the execution time.

As GSquared said,post the trigger and execution plan. You will get more help.

Peso (3/13/2009)

---

A good look at the reads required will reveal something

-- Peso

Table '#73E9A71D'. Scan count 7, logical reads 7, physical reads 0.

SQL Server Execution Times:

CPU...

I think it wont work in sql2000.

Also i don't know the date range. sometime it may start from today's date and end at jan/02/2009(working day) or it may end...

Hi ALL,

Again i need to do the same calculation but there is some modification in the requirement.

Create table Perf

(

ID intger,

Perf_dt datetime,

Net_Perf decimal(16,8)

)

insert into Perf

select 1,'13/mar/2009',-0.5567

union all

select 1,'12/mar/2009',-0.7865

union all

select 1,'11/mar/2009',-0.5887

union all

select...

Thanks RBarryYoung,

You know i have started to learn XML in sql2005 concepts from yesterday. I also wanted to display the second value,but i didn't find it in HELP. Anyway I...

I think lot of peoples are coming here for one day and leaving.

And...

is there any other indexes created to the table?

ahmad.kheir (3/12/2009)

---

yea its solved , thx very much for ur aid .

the problem was that the percentage of data selected is to big, so indexing does not improve the query...

Now the question is,

which method will give good performance?

Peso Method:

SELECTs.p_id,

s.qty,

s.nou,

(SELECT SUM(x.qty * x.nou) FROM Price AS x WHERE x.p_id = s.p_id)

FROMPrice AS s

SQL Server Execution Times:

CPU time...

Concur with Gail. Post the table structure with sample data. I am sure you will get good replies.

Yes. Both will give the same result.