Actually all the suggested answers are wrong. PAD_INDEX doesn't determine if space is left in pages and intermediate levels (the supposedly "correct" answer), indeed it doesn't even determine how...

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