Yes, I tried a few...

CELKO (10/28/2016)

---

Let's ask the poster; was this data from a spreadsheet or a string of some kind?

COBOL, COBOL, COBOL, you really should get yourself out of the '80s, it's...

Thanks Luis.

As I said already, it was an error introduced at the beginning of importing data, after I found the cause and re-imported the data, the issue doesn't apply anymore.

But...

It turns out to be something with the original data import, the function str is fine, and no need because the re-import fixed the issue.

Sorry for confusing.

found a simple solution: select str(column)

PS. the above query is producing wrong result, changing 1234565789 to 123456000, I'm keep searching for a simple solution now

I kind of remember I saw Jeff published a post somewhere about pivot, but just couldn't find it any more, maybe Jeff can post the link here again? Thanks.

Thank you very much. For people who read the post in the future, the final script is actually very simple and working:

SELECT Category, ColName, Value

FROM (SELECT * FROM [WeeklySummary]) AS...

Sorry the data looks so messy after it was posted. You got the idea though.

Thanks.

No, I didn't try as I don't know how to do it in a single query, I know for sure I can get it done using a stored procedure with...

ScottPletcher (9/3/2015)

---

I can't see the screenshot. A screenshot is pretty useless anyway. Actual text would be much better.

But, in short, here's the approach I recommend:

1) encode the large...

Jeff Moden (9/3/2015)

Since "RecordsWritten" is likely different for each instance of any single Network_Group_Name, you'll probably end up with a 40 million row return that simply duplicates the individual values...

The import process took less than half an hour and complete like an amazing miracle, and with no error even for the last line.

Thank you very much Luis for your...

Luis Cazares (9/3/2015)

---

halifaxdal (9/3/2015)

---

I found the issue:

The data row contains comma in one of the column, which makes the bcp thinking it is a delimiter.

Maybe I need to re-generate the...

I found the issue:

The data row contains comma in one of the column, which makes the bcp thinking it is a delimiter.

Maybe I need to re-generate the data by changing...