GilaMonster (10/13/2010)

---

http://sankarreddy.com/2010/10/invitation-to-participate-in-t-sql-tuesday-11-misconceptions-in-sql-server/

Start reading....

They're all linked in the comments of that...

Does this meet your requirements?

SELECT DISTINCT

id,

speak_flag = STUFF((SELECT ',' + lang

...

I would suspect that the line you're executing isn't correct.

Try putting an "echo %OpMode% %msISQL% Some_File.sql" to ensure that it's being called properly (you may need a "pause" in there...

Tom.Thomson (10/13/2010)

---

WayneS (10/12/2010)

---

Hey, first time for...

We used to perform our database back ups directly to a network location.

Until the SAN drive that was housing the backup directory had a hardware failure (very old hardware), and...

Please check out the two articles in my signature: CrossTabs and Pivot Tables, Parts 1 and 2. This should give you all the information you need for how to do...

Hey, first time for me also...

David.Parks (10/12/2010)

---

I have a package that loads multi flat files from a directory. Each file is named "Business Area - Date (e.g. DDA 10012010). The files do not...

Use IMEX=1 in the extended properties of the OpenRowset function.

GilaMonster (10/6/2010)

---

WayneS (10/6/2010)

---

Did I cover them in my article[/url]? If not, I'd love to know what you have, so that I can...

.... wonder if I can be a presenter for my "Comparing Table Variables and...

WayneS (10/11/2010)

---

Jeff Moden (10/10/2010)

---

WayneS (10/10/2010)

---

Hey gang... not definite yet, but my wife is talking about letting me spend the $ to go to PASS. 😀

Any suggestions on good, inexpensive, close...

From what I understand, she does - she's a hired...

Please take a look at the two articles in my signature: Crosstab and Pivot tables, Part 1 and Part 2. It looks like these will handle what you are after......

Does this do what you're looking for?

-- See how this starts off with a table and data in it?

-- If you had provided us the data in this format,

--...