Oh right - ok. In that case, I'll try to track down an excellent article which provides good evidence NOT to use built-in cursor updates but to do it manually...

Comment out the INTO as below:

SELECT distinct *

--INTO #RESULTS

FROM pr_linked

Set the...

It's highly likely that the folks here can replace your cursor-based code with a fast, efficient and pretty set-based equivalent - why don't you post your code and let them...

OPTION(MAXRECURSION 0)

100 is the default value. 0 = max limit.

faheemahmad14 (4/25/2013)

---

I have a table like that

MemberId(F.K) ! Event ! Event Date

1 'Test Event1' "2012-03-20 05:39:51"

1 'Test Event1' "2012-03-21 05:39:51"

1 'Test Event1' "2012-03-22 05:39:51"

3 'Test Event3' "2012-03-23 05:39:51"

2 'Test...

John Mitchell-245523 (4/26/2013)

---

Use DISTINCT when you want to eliminate duplicates from your result test. If you use it in an existence test, like you did in your original post,...

mister.magoo (4/26/2013)

---

Personally, for readability and your specific requirement, as long as you can guarantee the data type for PathIDs 30 and 31, then you can use this:

select DataId, PathId, Value

from...

L' Eomot Inversé (4/26/2013)

---

Maybe the entity owning the...

Evil Kraig F (4/25/2013)

---

Chris, as far as I know that's not bombproof. While under most circumstances the predicate will be filtered prior to the activation of the cross apply,...

This doesn't really address the point I...

What might you gain by putting phone numbers into a table separate from the entity (client, agent whatever) to which they belong?

Nice one, Geoff! Other than swapping around the sign on the hierarchy direction, it's bang on.

Try this...

-- This CTE search for the linked client(child)--

;WITH pr_linked(CLIENT_ID, NAME, LINK_CLIENT_ID, [LEVEL])

AS

(

SELECT CLIENT_ID, Name, LINK_CLIENT_ID, 1

FROM #PR_LINK_INV_HST

--WHERE LINK_CLIENT_ID = @CLIENT_ID

WHERE CLIENT_ID = @CLIENT_ID

raghuldrag (4/25/2013)

---

Hai friends,

I m creating one sample application its has two dropdown boxes ddl1 and dd2

if i choose dd1 in air

...