Digs (5/1/2010)

---

Jeff,

All works fine: And Fast !

I will keep your name on my list when I need to spend $$$ on my project .

Minutes have gone down to seconds...

As to the "Why", check out this link.

One thing to note there is that you can utilize a processing-instruction (thanks Jason & Paul!). So, this code might help you out.

declare...

huston.dunlap (4/30/2010)

---

I'm not here to discuss a specific problem I'm having, just a conceptual one to improve my overall understanding of SQL.

Let us say I am attempting to solve some...

CirquedeSQLeil (4/30/2010)

---

Lynn Pettis (4/30/2010)

---

Steve Jones - Editor (4/30/2010)

---

I dfon't think we need licenses for each person. That's why we'd go hosted.

Don't fret about $10-20 a month difference. Pick the best...

I'll be curious if you think the QOD's I have coming up (on indexes... only...

CirquedeSQLeil (4/30/2010)

---

Lynn Pettis (4/30/2010)

---

Should I be scared? Nearly half of those who have answered the QotD have gotten it wrong. Could be people not fully reading the question,...

Forget the cursor... try this instead.

-- See how this starts off with a table and data in it?

-- If you had provided us the data in this format,

-- it...

Not sure if this does what you need, but check out this link, specifically the XMLNAMESPACES. There's an example about 3/4 of the way down the page.

CirquedeSQLeil (4/30/2010)

---

WayneS (4/30/2010)

---

CirquedeSQLeil (4/30/2010)

---

Odd question just occurred to me.

Has anybody here ever tried setting their sa account password to contain emoticons? Or any sql logon password for that matter.

sa...

CirquedeSQLeil (4/30/2010)

---

Odd question just occurred to me.

Has anybody here ever tried setting their sa account password to contain emoticons? Or any sql logon password for that matter.

sa password =...

I like the idea of doing this, if it's actually performed by a third party and only aggregated results are sent to the company.

Hugo Kornelis (4/30/2010)

---

Great question, reminding people of an often-misunderstood and very important fact.

One minor letdown (hey! Other people moan about my questions, I get to moan back;-)) is the ambiguity...

Use this function:

CREATE FUNCTION [dbo].[DelimitedSplit] (

@list varchar(max),

@Delimiter char(1)

)

RETURNS TABLE

AS

RETURN

-- first, need to break down into separate items.

-- See Jeff Moden's article The "Numbers" or "Tally" Table: What it is and...

CirquedeSQLeil (4/29/2010)

---

The first site listed has email enabled such that an email sent to a specific mailbox will post the content immediately to the site for others to see and...

I realized I could have dropped the IsNull and just put...