BitBucket and Lynn,

I'll throw my hat in the ring in your favor. I can't argue as eloquently as Lynn, but I'll say this - you are absolutely correct. I'm in...

What you are discussing has been addressed by Lynn Pettis, you are referencing the mode...

Lynn Pettis has explained in great detail the reason the times are the same, and as a matter of fact has explained the reasoning better than I could have. ...

OK but give us a little additional information... what table(s) contain the information you need? How are the tables linked (Foreign key) or?

What have you attempted (your T-SQL...

You might want to look at the date part function in Books On Line:

DATEPART (Transact-SQL)

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/15f1a5bc-4c0c-4c48-848d-8ec03473e6c1.htm

This will give you an approximate answer:

declare @thisTime decimal(8,2)

declare @thisTime2 decimal(8,2)

set @thisTime = datediff(ss, getdate(), '11/22/2009')

set @thisTime2 = CAST(datediff(ss, getdate(), '11/22/2009')AS DECIMAL(8,2))/3600

select @thisTime AS 'Total seconds' ,@thisTime2 AS 'Total...

Trooper09 - Do you believe that the index fragmentation is effecting your performance? Which method of rebuild/defragging did you use?

From the same link that you posted: (Emphasis added)

http://msdn.microsoft.com/en-us/library/ms188917.aspx

Reducing Fragmentation...

I think that SSRS is NOT exporting data to EXCEL 2007.

From my Excel 2007 help file:

WorkSheet size 1,048,576 rows, 16,384 Columns.

Other improvements to Excel:

http://visio.mvps.org/Excel_2007.htm

If memory serves me correctly...

Specifically what error message is returned?

Suggest you read the articles on indexing written by Gail Shaw the 2nd of which is the featured article today

http://www.sqlservercentral.com/articles/Indexing/68563/

You also might want to spend time looking at these videos...

Modify the following:

;with numbered as(SELECT rowno=row_number() over

(partition by your duplicate column, order by Your duplicate column),col1, col2, col3 from your table name)

select * from numbered WHERE...

Greg Albrecht-252263

Greg it would help those who want to help you if you would provide further information. Is your date a DATETIME value, or is it month/day/year in...

alpeshgediya

A system administrator can enable the use of 'Ad Hoc Distributed Queries' by using sp_configure. For more information about enabling 'Ad Hoc Distributed Queries', see "Surface Area Configuration" in SQL...

Use the code posted by george sibbald-364359 to this forum.

Rather impatient aren't you... that said try this (Contributed by one unknown to me, prior to your asking the question. To this individual we both owe a hearty THANK...