twin.devil (7/15/2016)

---

If you want to do it in SQL SERVER then Tally OH! An Improved SQL 8K “CSV Splitter” Function[/url]

If you want to do in SSIS then check the following...

Which version of SSIS are you using?

wendy elizabeth (7/14/2016)

---

In sql server 2012, I want to allow a user to enter data into large columns that are used for different types of comments.

The largest varchar field that...

Ray K (7/14/2016)

---

I once had a friend tell...

Brandie Tarvin (7/14/2016)

---

jasona.work (7/14/2016)To quote the lady from Ghostbusters (1984): "WE GOT ONE!!"

:w00t:

The lovely Tahitian Island of Tahaa!

If I liquidate everything, I can come up with ~$400K, who else can...

Check out

Exec [sp] with result sets

in BOL.

I'm assuming that you've tried to do this and failed. What did you try and what errors did you...

muth_51 (7/13/2016)

---

Table has cluster index with default setting fill factor. The table has around 15 indexes including clustered. I just went through all indexes and some are set to fill...

Nice, Luis.

So you want something which handles different column names dynamically?

Eirikur, is your test database really called 'TEEST'? 🙂

peter 67432 (7/13/2016)

---

Good for this table, however i cannot change the tablename without changing the 'cross apply' part, so for my other table, i need to change the whole query,...

Perhaps this article gives you what you need to know?

You have not included 'e' (Extract). See info here.

Gus is right: make it work natively first, then plug into T-SQL.

Is your server really called 'localhost'? I know that works for default SQL Server instances, but I'm not sure about UNC paths.