Andrew,

I hate to break it to...

Can I just add, for anyone...

Reading further, it looks like you want to take the first Cancel of several as a match.

Which makes me curious. How are multiple cancels for one issue making it into...

Already with this you've violated your theory constraints. Your comment "When there is a matching...

Here's the R2 link: http://www.microsoft.com/sqlserver/en/us/get-sql-server/how-to-buy.aspx

Microsoft is making really hard to find the SQL 2008 regular stuff, but here's what I grabbed off Google. It's a download document, so be...

If the table needs to remain in Access (not recommended, btw), then you should be able to use OPENROWSET or some other similar T-SQL command to find the data you...

Andrew Collins (1/25/2012)

---

We have a sql 2008R2 Developer edition , and would like to have a linked server to a Live server to access data. is this allowed with...

GilaMonster (1/25/2012)

---

jcrawf02 (1/24/2012)

---

GilaMonster (1/24/2012)

---

SQL Kiwi (1/24/2012)

---

It's also the first five binary digits of 10001001 - a number I seem to recall has special significance to you...

Ah, good ol' Litespeed. Was this is a script generated by the Litespeed console?

What exactly are you trying to accomplish with the OUTPUT variable?

It doesn't actually sound like you're using Database Replication (which is an actual feature). If I'm reading this right, you're just using a job to do a data grab. Correct?

Ditto to Jeff Moden's version. It is probably the best, and most highly recommended, splitter code I've seen.

And it works.

pinwheel

L' Eomot Inversé (1/24/2012)

---

Evil Kraig F (1/24/2012)

---

Ah, thank you....

GAH! You missed EVERYTHING.

Here, read this post:

http://www.sqlservercentral.com/Forums/FindPost1238567.aspx

http://www.sqlservercentral.com/Forums/FindPost1240109.aspx

Buy a copy. Review it! Be amazed!

Oh, and tagging is also encouraged.

Almost forgot. The Nook version is out now too:...

Cadavre (1/24/2012)

---

Brandie Tarvin (1/23/2012)

---

The sample can be found here (in .pdf): http://www.crazy8press.com/wp-content/uploads/2012/01/Unlatched-teaser.pdf.

The blog post with the sample link is at: http://www.crazy8press.com/2012/01/12/sample-the-first-latchkeys-adventure/%5B/url%5D (in case you don't want to go directly to...