asifejaz (7/4/2013)

---

thanks for your quick response. really appreciate that.

This will solve it but urpose is not achieved. i am using a cursor to fetch records with combination of primary...

Hi Dave

Please refer to this Connect article which provides an explanation and a temporary fix. The issue appears to be...

What's returned when you run this:

SELECT DISTINCT rel_value

FROM agr.dbo.relvalue AS relvalue

WHERE (attribute_id = 'A0')

AND (rel_attr_id = 'ZL')

AND rel_value LIKE 'U%'

It's SQL Server 101, and I'm surprised that the tests for a BI position can be this simple. If you...

Steve

Take another look at this part of the query:

SELECT

SVPromoInteractions.RefKey

FROM SVPromoInteractions

INNER JOIN (

SELECT

RefKey,

MIN(ContactDate) ContactDate -- Finds the oldest interaction, in case there are more than one 321 rec

FROM SVPromoInteractions

WHERE INum =...

How are you consuming the output, Amy? At almost 3M rows I'm guessing it's part of another query, in which case I'd look first at bundling up the faster query...

sachince61 (7/2/2013)

---

Thanks for your reply..

Its very much helpful to me..

But i want to know is there any other way without using ROW_NUMBER() function ??

B'cause i am using server 2000 so...

-- This should work but the output does not match your "desired output" table.

-- If you can explain why there is a difference then I'm sure the code can

--...

Yes I can see that! How does the list come into existence? Is it typed in by you or generated...

Steve

The indexing strategy...

How is this list (50200,50194,50430,50191,1) generated? Could you leverage the method to create a two-column table instead?

Limping! 😛

I'm...

The query with the redundant outer select times out - SQL Server effectively gives up trying to find the...

T.Ashish (7/1/2013)

---

Yes, I used Andy's suggestion and it was working fine. After that, Optimizer was suggesting some index. Instead of creating index, I put all the query inside another query.

...