Remember to add in IsNull/Coalesce around the columns in the inner query. Otherwise you'll be missing columns in the output string for some rows.

It has ampersands in the data. There needs to be a replace step to clean it into real XML.

Whomever designed the database he's using, they made a number of...

Here's a skeleton that should get you started. You should be able to see how the rules work in it and customize them as you see fit.

/*

Horse Name Ranking...

My first instinct on reading the title and intial requirement statement was to suggest snapshot replication.

However, for something twice a month, I'd suggest a simple SSIS package, or even a...

Do it in two steps.

Parse out the value, into a temp table or a variable, then convert it to datetime.

Or skip all that and use XQuery as per my example....

Pretty safe assumption you've already resolved this, but if not, what is blocking and what is eating up resources?

Kit G (6/1/2011)

---

Hi Wayne,

Thanks for the reply but that doesn't quite answer my question. The code works. What I'm trying to figure out is WHY it works so...

On the other question about XML escape characters in the results (the & amp bit), you'll need to (a) wrap your fields in IsNull or Coalesce functions to make sure...

Kit G (6/1/2011)

---

Before I use this construction, I want to understand what I’m doing. So, plucking that out of the CTE, I try this snippet of code

declare @BatchSize...

It looks like a Select with an Outer Join should do what you need.

select pin, Rule.Date

from [Pins]

cross join [Rule]

left outer join [Registry]

on [Pins].Pin = [Registry].Pin

and [Rule].Date = [Registry].Date

where [Registry].Date is...

Is there a trigger on the table you're trying to insert into?

WayneS (5/31/2011)

---

Hi GSquared,

This is meant to be run one time to create the procs, that are then used to get the data. Of course, they need some modifications to add...

LutzM (5/31/2011)

---

Gus, you didn't take...

The question becomes, if more than one row qualifies to fire the trigger, do you send more than one e-mail, or will one e-mail accomplish what you need? What...

Craig Farrell (5/31/2011)

---

GSquared (5/31/2011)

---

jcrawf02 (5/31/2011)

---

Actually, the real acronym is almost funnier than the ones you guys came up with, when used on a forum:

Do Not Resuscitate

We should put that on...