6k rows is not really not that much to look through. Full Text indexing can make that sort of thing happen pretty fast.

--EDIT--

Seems that Anthony was quicker on the draw...

Going by the dictionary definition of age, "The length of time during which a being or thing has existed.", I have to say that negative age does not make much...

I want to Count the occurances of BOM_BAR_ID and summarize the PIECE_LENGTH per BOM_BAR_ID. I want all the like LENGTHS to be together. Each BOM_BAR_ID represents a piece of material...

Actually I think that a negative age has some real value if you think of age not as only the age of a person. What you are calculating is the...

Does this work?

ISNULL(YourDate, '2050-12-31')

Glad you figured it out. I had a feeling it was stale statistics.

mdsharif532 (1/8/2013)

---

DECLARE @BIRTH_DATE DATETIME, @STPR_START_DATE DATETIME

SET @BIRTH_DATE = '1975-01-07'

SET @STPR_START_DATE = '2013-01-06'

SELECT DATEDIFF(YEAR, @BIRTH_DATE, @STPR_START_DATE)

Result: 38

SELECT DATEDIFF(YEAR, @BIRTH_DATE, @STPR_START_DATE) - CASE WHEN MONTH(@BIRTH_DATE)*100 + DAY(@BIRTH_DATE) > MONTH(@STPR_START_DATE)*100 + DAY(@STPR_START_DATE) THEN...

Hi and welcome to SSC. In order to provide any help you need to first provide enough details so we know where to begin. You will need to post ddl...

Estimated execution plans don't really help much. Performance problems can be difficult to determine the root cause. Are you running this query just like this or is it a stored...

You really should look at the link I posted. It is simple,...

mdsharif532 (1/8/2013)

---

Just follow the sample code, hope it will help you to get start.............................................

declare @index integer

set @index = 1

DECLARE @C_YEAR VARCHAR(4)

SET @C_YEAR = 1995

DECLARE @TEMP_TOTAL TABLE

(

TERM_REPORTING_YEAR decimal(4),

TERMS_ID...

zulmanclock (1/8/2013)

---

Is there a way to have a query run for only lets say 1 minute and have it return results? I am trying to compare 2 queries and...

There are tons of articles and forum posts around here. This is about the best in my opinion.

http://www.sqlservercentral.com/Forums/Topic796803-338-1.aspx

PiMané (1/8/2013)

---

Sean Lange (1/8/2013)

---

Creating views sounds like a better approach. If you have data that is related to the customer but is not as important then splitting to an extension...

PiMané (1/8/2013)

---

Sean Lange (1/8/2013)

---

Since you are using a correlated subquery why bother with any of those approaches?

This returns the same thing.

select *

from seats s

join seats2 s2 on s.ID =...