scotdg (2/26/2016)

---

I have a job that I want to run that passes a variable to an ssis package. The variable is a filename but the filename changes daily. I have...

Not at all.

TheSQLGuru (2/24/2016)

---

1) Please provide create table statements, sample data via INSERT statements and expected output cases to back up what you are asking. I can't make heads or tails of...

If you post the actual execution plans for the queries you detailed, it will be helpful to others.

SSIS is not going to perform raw data processing work any faster than the SQL Server database engine. In fact, it will usually be slower.

Therefore trying to move everything into...

Jeff Moden (2/24/2016)

---

I definitely wouldn't use XML for anything even close to this. Also, computers don't "easily" read XML. There are programs that make it easy for Developers...

peggy.carstens (2/24/2016)

---

I can write the SQL to pull both the header and detail records (duh!). It's the time it takes to pull the data that's the issue. Is...

donstarter (2/24/2016)

---

Thanks for your input Phil,

Yes, I can see the difference of the strings when pasting into Notepad++ kind of same as I see the difference when doing a hashbyte....

jasona.work (2/24/2016)

---

So a question to everyone: Would you prefer if someone posts a quick "reported as spam" reply to the spam topics after they report them, or nothing? ...

donstarter (2/24/2016)

---

Hi all,

I am having an issue with using distinct on one single column in a table and getting multiple result rows for a string "looking" the same. When I...

peggy.carstens (2/23/2016)

---

I have a large Sybase database that has 150M+ claim (header) records and 190M claim line (detail) records. We want to bring over the last 3 years of...

Jeff Moden (2/23/2016)

---

Heh... good grief. 1500 nodes. And it's not flat. It does...

Any XML gurus out there who would like to help?

http://www.sqlservercentral.com/Forums/Topic1763386-3412-1.aspx

--Edit: fixed garbage English!

OK, maybe this works...

astrid 69000 (2/23/2016)

---

Hi,

I take data from different xml therefore the structure may vary, and I need to bring it to a table so the data science can run a statistic...