I don't think there's an issue here. There might be a small conversion, but it can't be much. There can't be a "bit" in the register. It will load as...

I'm here. Around a doctor's appt for my...

Happy New Year!

Also, I can repeat column names. Just need an alias.

SELECT a.myid

, a.mychar

, b.myid

FROM dbo.mytable2 a

INNER JOIN dbo.mytable b

ON...

As Chris mentioned, we can't determine how you match up rows. What determines that the row with "a" matches the row with "c" and not "d"? If you can't logically...

'donks

Boo, Pats

chrisn-585491 (12/31/2014)

---

As a Jack-of-All-Data-Trades, certification is huge time suck for me. As soon as I'm ready for an exam, it's retired and there's yet another two new versions of SQL...

You are...

As Lowell suggested, I'd use SQLMail.

We used to send the newsletter here from SQL2000. It can be done at lower volumes (1,000s/day).

What I'd do is load an email table with...

I think DAS was coined when expansion boxes attached to servers using external SCSI connections. This distinguishes it from storage across a network using HBAs, SAN, iSCSI, etc.

You are correct...

Aside from what Lowell wrote, if you have truly filled up all the space with data, you'll need to archive data and then delete it to free up space.

I'd use the solution above to concatenate the values.

You'll have to provide more details on what you are trying to achieve. A cross join is a product of all possibilities. If that's what you need, that's what...

Robert Sterbal-482516 (12/19/2014)

---

I think my evenings are limited to once a week for all practical purposes for the foreseeable future. What is the second best way to get out there...

Gary Varga (12/19/2014)

---

For sure. This is mostly my plan, though I lose 10-12 a year for events....