Warning - Accessing a SQL Server DB in this way from excel can be prone to causing blocks, maybe not as bad as from Access but something to watch out...

I need something similar, but I need the daily median of a data set, effectively doing a group by on the Date.

Only way I've found to do this is with...

I so wish this worked with 2000

Look @ the following article

http://www.sqlservercentral.com/articles/SQL+Puzzles/eliminatingcursors/2223/

Does the case not cause very similar performance problems, I remember having to rewrite an SP a little while ago to improve performance by removing the case from a where...

try something along the lines of

select * from table_name where convert(varchar(11), Created_Date, 106) = convert(varchar(11), @varDate, 106)

Good article, I guess the same applies to the use of case statements in the where clause which the performance hit has caused us to rewrite a few SPs!!!

bet its not 😉

Does anyone have a link to some examples of scripts using cursors and the same scripts without the cursors, I used to have some good examples but can't find them...

Cursors existed in 4.2 (Now Im showing my age) and as far as I could remember could achieve results we could not get any other way. SQL server was extensively...