http://serverfault.com/questions/91285/how-do-i-remove-a-specific-bad-plan-from-the-sql-server-query-cache

Okay have you tried inserting records into a temporary table on individual conditions yet?

So to see if it's a particular condition that's causing the long wait separate them to...

maysoonshahin:

Couple suggestions. Let me know either way if anything isn't clear.

# 1) Please don't use the "select (*) " in your code. Only select the "required"...

Wrong query. sorry

How about showing some code?

SET NOCOUNT ON

DECLARE

@RowCnt INT

...

Sorry I had some (back at work fires) to put out. 🙂

Here's an approach that'll help you out a bit. Remember you can assign values...

You can keep breaking it down more as needed.

Does this get you closer?

SELECT CONVERT( CHAR(10), sosb_CarDetail_DateReleased, 101 ) AS [DateReleased]

, Count( sosb_CarDetail_CarNumber ) ...

So just so that I don't go in the wrong direction is this something towards what you are looking for?

SELECT CONVERT( CHAR(10), sosb_CarDetail_DateReleased, 101 ) AS [DateReleased]

...

How are you looking at presenting the data? Do you need one table showing all the details or what will be displaying the information out?

Are you still looking to solve this?