If you want the months converted from numbers into names, try the following:

select

CASE DatePart(month,Date_occur

There are 3 impacts of using select *

1. If the table is indexed, the index won't fully cover the query so extra IO to access the underlying table to get the...

Hi Tim, are the machines in a Domain or Workgroup?  If it's a domain, I don't have much useful to add I'm afraid, but if it's a workgroup then I've...

p.s. If they've already got high permissions, you can selectively turn off permission to change a stored procedure like this:

DENY

ALTER ON

I've only tried this against SQL 2005, but it works fine there... maybe it'll work on SQL 2000 too?

GRANT VIEW DEFINITION

One possibility is to delegate the query string building down to the stored procedure instead of doing it in your application code.  You'd just pass in the search string as...

DISTINCT is definitely a bad idea, performance-wise. Avoid if at all possible as it usually involves having to sort the result set and then scan through it, making lots...

Thanks guys.  I've got the procedure working about 95% more efficiently than it was initially, I think I'll leave it at that