ACinKC (6/18/2012)

---

It appeared to me, just like the other post that Brandie quoted, that you had felt you had to proactively throw up a defense against some kind of attack...

Oksana March (6/16/2012)

---

Hi Craig,

Can you help me understand this better? I would not be able to explain it to my rubber ducky for sure, if I had one 🙂 I...

Unless, of course, you're creating code that someone who's working on older systems will be able...

Here's the best I've got for now...

dj1202 (6/15/2012)

---

Evil Kraig F (6/15/2012)

---

dj1202 (6/15/2012)

---

There are duplicate dates (each correspond with a unique invoice number). Therefore, it will not let me assign. Any suggestions on how one should approach...

Like so? (btw, thanks for the easy to use data)

SELECT

SUM( Value) AS SumValue

FROM

(SELECT

--DATEADD( dd, DATEDIFF( dd, 0, DateTimeStamp), 0) AS DayOfRecord,

MAX( DateTimeStamp) AS MaxDT

FROM

#Test

GROUP BY

DATEADD( dd, DATEDIFF( dd, 0,...

I'd have to go...

This really doesn't work for Full-Text. Full-Text indexing's purpose really is single column use. However, you may want to investigate the Fuzzy Lookup component in SSIS. It,...

Merge's power is in the single transaction / modification capability for both sides of the Upsert, which implies multiple rows, and not having to double-pass the data.

By doing a select...

Lynn Pettis (6/15/2012)

---

Brandie Tarvin (6/15/2012)

---

Craig, I read the "Devil" comment to refer to the evil commenters who make people post things like "please don't flame" and "put me over the...

Revenant (6/15/2012)

---

ACinKC (6/15/2012)

---

I think it's more widespread than some might be aware of, which means that the problem is that some aren't even picking up that the way they respond...

dtoews 7666 (6/14/2012)

---

This seems to work, Kraig. I had gotten to the point of the self join, but I had no idea about the XML PATH command to bring...

I believe I can sum up the difficulty with Oracle compared to SQL Server with a quote I once heard an old Mainframer tell me when I started.

"If it's not...

Personally, I'd look at how your restrictions are actually working. The reason for this is because date in this case as the leading edge is probably not your best...

First, let me say nice work on the data setup and results, however, you didn't test it and you missed a spot. It needs quotes for the text entries,...