Steve Jones - SSC Editor (1/26/2007)

---

My son was telling me about an XBOX game this week, so I guess I got influenced <img src='images/emotions/smile.gif' height='20' width='20' border='0' title='Smile' align='absmiddle'>. Glad...

It depends....

....on whether I'm allowed to call a slightly dishonest...

Cadavre (11/4/2011)

---

SQLRNNR (11/4/2011)

---

The...

Tallboy (11/4/2011)

---

Thats what I am asking is it normal practice.

There would be more than 1 task/organisation id to find as the task that the staff member is being paid for,...

One way to do it is

SELECT REVERSE(LEFT(REVERSE(Document_and_path), CHARINDEX(REVERSE(Document_and_path),'/')-1)

FROM dbo.Docs

edit: I see someone else posted the same way of doing it while i...

Nice, good, easy question.

I forgot to drink lunch before answering, so my inadequately lubricated brain got it wrong.

Kiara (11/4/2011)

---

Yup. But when I've been testing, they seem to do less r/w activity than temp tables do. Could just...

I'm inclined to say that frequent password change is a bad thing; but of course it's necessary when once you have shared passwords both because people leave and because shared...

nicko5 (11/3/2011)

---

It seems to me you would just want to insert a single email address into two separate tables. If so, you would use the following:

create procedure RS(@emailtable as...

There's nothing in recursion that prevents set-based description. The fact...

The main thing is not to let the sheer amount of information overwhelm you - recognise that there's more than you can ever learn, realise that the same applies to...

Here's some code that does that: it orders the groups by their max price (descending), and the rows with a group by their price (descending). Uses table name "thing"...

Are the paths for the master database correct in the registry? I don't know where paths are in sql 2005, but my 2008R2 installation has them in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL...

SQLRNNR (11/3/2011)

---

Walkout

Nice question. Pity it says 2005 onwards instead of 2008 onwards, as none of the answers match 2005 behaviour.

I'm not sure whether to agree with Hugo's interpretation of "correct"...