faisul (3/23/2009)

---

Thanks for you replies : peterzeke, Christopher Stobbs

I take on board all you have suggested, is there any recommendations you can make regarding the script. I need to correct...

mister boom (3/13/2009)

---

That returns 'Conversion failed when converting the varchar value 'text' to data type int', as I expected. However, for some reason, if you change the first 0 to...

mister boom was on the right...

Gail beat me to it!

Kev

ramadesai108 (3/13/2009)

---

ok here is my updated code:

CASE ClientID WHEN CHARINDEX('-',ClientID) <> 0 THEN

(CASE WHEN ISNUMERIC(SUBSTRING(ClientID ,CHARINDEX('-',ClientID ) + 1, 5)) = 1

THEN CONVERT(INT,SUBSTRING(ClientID ,CHARINDEX('-',ClientID ) + 1, 5))

ELSE...

Can you confirm what datatypes 'ClientID' and 'vchClientSubSessionID' are.

Also some example values of ClientID

Kev

Terry,

it was originally posted on 30 June last year - Steve sometimes recycles popular articles.

If you look on SSC homepage, under the headlines it says

By Lynn Pettis 2009/03/13 (first posted:...

Any SSC regulars going?

I am and would love to put faces to names.....:w00t:

Kev

mike.woodward (2/16/2009)

---

I agree with the previous posters about avoiding "*=".

However, doesn't "*=" equate to RIGHT OUTER JOIN ? thus the two sql pieces of code are not the same....

Probably to do with NULLs and the way they get interpreted by the WHERE clause rather than the JOIN clause.

See http://www.sqlservercentral.com/articles/Basic+Querying/ansijoins/189/ in the section entitled 'Outer Join Gotchas'

Kev

Rachel Byford (2/11/2009)

---

In SQL 2000 Query Analyzer it formats the text as if PRINT '7' will happen, and yet it doesn't when you execute it. They must have updated...

archie flockhart (2/11/2009)

---

Got it wrong , read the answer/explanation, didn't really believe it, so tried it in Query Analyser which gave the answer stated as the solution. But...

Philippe Lauwers (2/11/2009)

---

I could hardly believe I got it wrong, so I tried it in DbVisualiser ... I got 1,4,5,7,8 (just as I thought I would). Could this have something...

Ken McKelvey (2/4/2009)

---

Robert - App Locks can be made to apply to the current session and not just the current transaction. It is then up to you to explicitly release...

Haha - soooo true!

Kev