(Sorry for two posts. Had to take a minute to find this.)

Take a look at this, see if it helps: http://www.sqlservercentral.com/Forums/Topic1144535-391-1.aspx

Which flavor of replication are you using?

And I dropped out of both kindergarden and college! But I've got a well-paid DBA job anyway.

It's been a while since I used DTS. In SSIS, what you're asking about is trivially easy.

You use an SQL task to query table 2, then a For Each...

Brandie Tarvin (12/22/2011)

---

Since it's doubtful I'll be around for the next four days...

Happy Holidays to anyone who celebrates. And happy long weekend to those who don't celebrate but take advantage...

David Moutray (12/22/2011)

---

Does it seem wrong to anyone...

Sounds like full text indexing would do exactly what you need. I've used it on multi-million row tables and get results in sub-millisecond on a regular basis, for very...

There are two easy ways to do this:

First (and usually best) is have a calendar table. Query that and either join it to the other table(s) or use a...

Nah. They didn't actually show any birds falling to their doom, just people running in panic.

As they...

David Moutray (12/22/2011)

---

Very funny article! Actually, I like the term "Rooster Booster" better than "Bird Cannon." :hehe:

That reminds me of the Thanksgiving episode of "WKRP in Cincinnati" (an...

They're SSRS reports you build.

Here's an article on it: http://www.simple-talk.com/sql/sql-tools/custom-reports-in-management-studio,-using-the-performance-dashboard/

David Moutray (12/22/2011)

---

I like the phrase "High Velocity Pork Chop!" It is wonderfully obscure. 🙂 Although, I think I prefer the imagery of a "high velocity meatball." ...

I'd use a GOTO if I felt the need. Mostly though, the "Not-a-GOTO" statements handle it these days. So I haven't used a literal "GOTO" in T-SQL in...

Dev (12/22/2011)

---

Thanks Gus. I knew SQL Server Join syntax (Non ANSI). I was just trying to recollect whether Oracle Syntax was portable to SQL Server (or vice a...

Sapen (12/21/2011)

---

If an index has been added recently then you can try to get creation date from the default trace file otherwise there is no way you can do it...