XML is case sensitive.

This should help you get moving

SELECT

t.b.value('(MsgID)[1]', 'NVARCHAR(1000)') AS MSGID

, t.b.value('(MsgTime)[1]', 'NVARCHAR(1000)') AS MsgTime

,...

GSquared (6/15/2016)

---

This can turn into a complex question. The rule-of-thumb that I try to follow on things like this is: The more clever the solution has to be, the...

Yes and no. I'll be doing some content here to explain how this works and how you can use it, but I'd encourage you to play with it in a...

Take it Keith. Should be short and easy.

Cheers, and glad it worked. Sorry I didn't think of it 🙁

TheFault (6/15/2016)

---

Having worked at a company who are supposed 'industry experts' in data security, I can tell you it is no better behind closed doors at such places. PCI audits...

I'd go with the ADO.NET driver and SSIS, personally. Haven't done it, but if you're just moving data, this is fairly straightforward. Even the programming part isn't bad. I would...

My vote is never, never combine the drives unless this is a LUN from some storage system. You can have multiple files in one filegroup or multiple filegroups, but manage...

Meet 3-5 new people. Just say hi, introduce yourself and ask what they do. Or why they're there. Spend 3-5 minutes getting to know them. More if you want, excuse...

Yes and...

Yep, click the discuss link on the main page for the question. Or check the author's forum.

No need to answer to discuss. I rarely answer 🙂

Ichiro closing on Rose' record: http://espn.go.com/mlb/story/_/id/16198037/pete-rose-counting-ichiro-suzuki-japan-hits-record

For the record, I don't think he's the MLB hit leader, but maybe the world baseball hit leader for sure. He's been amazing. 1200 in...

From MS:

Use -P "", double quotes, which should work. I'm guessing this might work for SQLCMDPASSWORD as well.

If not, can you use isql/osql instead?

No idea. I'm not even sure how to set a password to NULL. I can set it to blank, but not NULL, at least not that I see in 2014/2016.

If...

That won't scale well, as you'll end up with wide tables as the clients grow, where many of the columns are null.

The other way to do this is customize the...