You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables...

Paul White NZ (10/2/2010)

---

Local news: Lots of changes on 1 October. GST went up, income tax came down, and Internet bandwidth increased to 15Mbps from 10Mbps. And I'm...

I agree with Luke that Shaiju CK's implementation isn't that good. However, a PIVOT won't work unless there are the same # of names.

So, here's a working solution:

DECLARE @tYourTableName TABLE...

CREATE PROCEDURE dbo.LoadXMLData (@xmlData XML) AS ...

then use @xmlData.nodes()... to get the data out.

Clkgtrs1 (10/1/2010)

---

Hey Thank you for the help but when I right click the database I don't have the option to import data into my database. I'm running SQL Server Management...

Craig Farrell (9/29/2010)

---

... I've gotten a list of questions that I always ask the employer. One of the top 3 is "What's your average employee's work schedule like, including...

I'm assuming that you're then using Excel to open the CSV, and want all of the column's auto-sized?

Setting the width in a CSV file defeats the nature of a...

Jeff Moden (9/30/2010)

---

WayneS (9/26/2010)

---

Jeff - just saw this thread after returning from my vacation. If needed, I can run this on a Vista Ultimate 64-bit laptop, on 2005 / 2008...

Trey Staker (10/1/2010)

---

Alvin Ramard (10/1/2010)

---

Jason,

After looking at that thread you just posted in, I think it's time to write up a best practice for SSIS configuration and deployment.

I'm getting tired...

I've been having sporadic...

Great question; I really enjoyed working through it. Thanks!

Craig Farrell (9/30/2010)

---

CirquedeSQLeil (9/30/2010)

---

Grant Fritchey (9/30/2010)

---

CirquedeSQLeil (9/30/2010)

---

WayneS (9/30/2010)

---

CirquedeSQLeil (9/30/2010)

---

GilaMonster (9/30/2010)

---

The problem is what he's mapping out in the project plan is actual elapsed time, not time spent on his project....

Sachin Vaidya (9/30/2010)

---

Where did I mentioned...

CirquedeSQLeil (9/30/2010)

---

GilaMonster (9/30/2010)

---

The problem is what he's mapping out in the project plan is actual elapsed time, not time spent on his project. Since neither developer is full time (both...

http://social.msdn.microsoft.com/Forums/en-US/sqlkjreportingservices/thread/4d561071-342f-4dc8-a361-a71d0cc1d93d

I don't actually have R2, so I can't tell you any more than what...