Um - but now the event is full. I'm sure there will be plenty that will come to see the session. Hopefully you can blog about it for us less...

You're welcome. One consideration which may not be valid but if you have two entries with null end_date's that previous will not work. The following will (included data that I...

Just a quick warning but I have had those portable drives crash a server before so, test on a non-production box to see how it responds to connecting that up....

This should get you close;

selectb.Badge,

b.Site,

b.Extension,

b.start_date

fromBadgeSiteExtension a inner join BadgeSiteExtension b

ona.Badge = b.Badge

and a.Site = b.Site

and a.Extension = b.Extension

and b.start_date > a.start_date

and b.start_date < a.end_date

So, yes a...

jasona22 (3/22/2011)

---

Thank you David.

I do not know nor really understand SSIS. I can't even spell SSIS <-- note red squiggly

As for manually writing transfer TSQL (or SSIS), that is...

jasona22 (3/22/2011)

---

Yes, my goal is to move several databases into a single.

As an example, I have 10 databases that have no network connectivity in remote areas of the world. ...

jasona22 (3/22/2011)

---

I have a series of remote databases detached from any network. I need to aggregate the data into a single repository. My plan is to receive .bak...

Might be good to attach the plan so that it can be reviewed. Thanks.

Thanks Ninja. I'll be certain to share.

Ninja's_RGR'us (3/22/2011)

---

GilaMonster (3/22/2011)

---

Ninja's_RGR'us (3/22/2011)

---

Alright, I was wondering if you have taken that task on and had...

Glad that worked for you. 😀

GilaMonster (3/21/2011)

---

Second request, seeing as I seem to have scared people away

I'm looking for a couple (and I do mean 2) editors for a non-SSC piece on page restores. Please...

SQLkiwi (3/21/2011)

---

About 40 minutes short of 24 hours travelling...

Glad that worked. Typically I would start looking at the wait stats for the rollback process to ensure that it is actually doing something. Regardless, glad things cleared up.

Stefan Krzywicki (3/21/2011)

---

Roy Ernest (3/21/2011)

---

Thanks Stefan and Grant.

Have anyone heard of Hampton Inn in Plymouth? If so what do you think?

She is crying when I told her that...