drew.allen (5/2/2012)

---

GSquared (5/2/2012)

---

Per what?

The Outer...

MdApache (5/2/2012)

---

GSquared (5/2/2012)

---

MdApache (5/2/2012)

---

I used to be a strong believer in regular funding of my retirement account, but now I'm less likely to do so. The finances for the...

stephanie.sullivan (5/2/2012)

---

So I either gain by funding it, or I don't lose anything that matters in the long run by funding it, so I fund it on a "why not"...

MdApache (5/2/2012)

---

I used to be a strong believer in regular funding of my retirement account, but now I'm less likely to do so. The finances for the USA are...

L' Eomot Inversé (5/2/2012)

---

TravisDBA (2/17/2012)

---

Just let people give their opinions/experiences here without resorting to calling there opinions "silly". Please treat people with respect without resorting to calling them or their...

SQL Kiwi (5/2/2012)

---

Client ID would need to be a key to avoid duplicates there.

You could also...

j_e_o (5/2/2012)

---

Actually, I am living the answer to most of what we have been discussing. Quite a few years back, my company embarked on a journey to embrace agile...

I think it depends on how you look at it.

Sure, nobody has the final regret "I wish I'd spent more time at the office". (Well, it's not usual. ...

The easy way to do this with SQL 2008 (as per the forum this is posted in), is to Cross/Outer Apply from your Clients table to this table.

SELECT *

FROM dbo.Clients

OUTER...

You have to build your own loop for that, instead of using a recursive CTE.

At each iteration of the loop, check if any values already exist in the result-set. ...

michael vessey (5/2/2012)

---

to find the first instance of a character in a string use "charindex"

to find the last instance use a combination of charindex and REVERSE

select LEN(col3) - CHARINDEX('A',REVERSE,col3)) as...

drew.allen (5/2/2012)

---

Cadavre (5/2/2012)

---

WITH CTE(n) AS(SELECT 1

...

When you say "max occurence of alphabet 'A'", do you mean you want the position in the string of the last "A" in it?

If so, something like this will find...

They do the same thing. Probably even use the exact same binaries behind the scenes where SQL Server does all the actual work.

So use CURRENT_TIMESTAMP if you can. ...

Career path? I've never considered this even important, much less critical. I do my job, my skills continue to evolve and improve as I teach myself new things...