Lowell,

Thank you so much for trying to help me.

The code is running on SQL Server 2000 machine.

row_number() will not work.

Sorry Lowell.

You are absolutely right I should have posted some SQL code

to re-produce my task.

Lowell,

I probably need to explain a bit what COB and TimeStamp columns are.

[COB] is Close-Of-Business date....

I updated the ATTACHMENTS post.

Go to:

http://www.sqlservercentral.com/Forums/Topic780116-360-2.aspx

and look for the post that starts with:

ATTACHMENTS. UPDATED!

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

I inserted prints everywhere.

For example, this query

if @statsFlag = 1 print '\\\ insert #CreditSpreadCurve_subset'

insert

#CreditSpreadCurve_subset

(COB,

Instrument,

Spread)

select

COB,

Instrument,

Spread

from

CreditSpreadCurve

where

COB = @COB1 or COB = @COB2

if @statsFlag = 1 print...

I am stll not sure how to count queries.

Here is what I mean.

This query has 4 lines:

print 'location=1'

select count(*) from BondSpread where COB = '8/31/2009'

print 'location=2'

select count(*) from BondSpread where...

I used SET STATISTICS ON option

and it returned:

...

SQL Server Execution Times:

CPU time = 63 ms, elapsed time = 88 ms.

SQL Server Execution Times:

...

I assumed you can figure out what are the slowest parts from that STATISTICS output.

Am I wrong?

Anyway,

I didn't run all the pieces of code separately again today but from

what...

Gila,

sp_help returns a whole bunch of grids.

Can I get results as Text?

ATTACHMENTS. UPDATED!

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

OK.

I saved all 20 grids from Query Analyzer

and pasted to "DSR_Validation.xls". It is attached.

[CreditSpreadCurve] view table definitions and indexes are also attached.

Question.

How do I get table definition with all...

Gila,

I followed your instructions from

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

but "SET STATISTICS PROFILE ON" generated 20 grids.

Do I have to copy each one of them and paste it to Excel?

I tried SET SHOWPLAN_TEXT ON

and saved it as TEXT file.

See attachment.

Probably Table Definitions won't help you much

because there is no way we can change anything there.

ALTER view [dbo].[BondSpread] as

select...

It's SQL Server 2000.

Is there any way to show you Exec Plan in 2000?

I did right click in the Execution Plan Tab but "Save Execution Plan As.." is disabled.

Yes, I can post all the stuff.

I just forgot how to save Execution Plan as a text file.

The problem is solved.

I just filtered [CreditSpreadCurve] by dates;

"...WHERE COB = @COB1 or @COB2..."

and inserted it in a temp table #CreditSpreadCurve_subset,

then joined with this temp table.

The query ran 21 sec.

Ho-ho!

It's...