And then, examine the code... most performance problems have nothing to do with the hardware and sometimes not even with indexes.  Got cursors?  Got WHILE loops?  Got views with aggragate...

PLEASE... take the time to show some data before and after the function gets done with it... it sounds like you want a table function but we can't tell for...

David's solution is almost correct, but not quite... the resolution for DATETIME datatypes is 3 milliseconds... David's solution rounds up to midnight... you need to do this instead...

SELECT...

Concur... and, if you do it right, don't even need that... the "External Data Ranges" can be setup to "auto-magically" refresh on open.  In Excel 2k3 and above, you can...

No, but press the {f8} key in query anlyzer to reveal the "tree"... drill down to the table you want, right click on it, and read the menu that appears......

I guess I'll never understand why folks try to push data into Excel when the "Get External Data" feature in Excel works so very well...

Sam,

Recommend you read the following URL... especially Q3/A3 and Q4/A4...

http://support.microsoft.com/default.aspx?scid=kb;en-us;305977&Product=sql2k

... personnally, I only use a table variable if I can't use a temp table... that would be only in...

Just curious... can Oracle supply the default as you've stated?

Thanks, Evan...  appreciate the feedback.  Just remember that with these types of things (cross tab), the whole result set must materialize before criteria will work on it (which is why...

I know, Serqiy... and I agree... I was just trying to avoid the UDF just for fun.

You can code a default for each parameter passed to an SP... from BOL... does that help?

CREATE PROC [ EDURE ] procedure_name [ ; number ]

    [ { @