No need for a temp table....

kewlguy13 (7/15/2016)

---

Hello Eveyone,

I am struck with Junk dimension.

My target table structure is as below.

Junk_Dim

----------

JunkID -- PK

JunkTypeID -- PK

JunkCode

JunkName

JunkTypeName

Below values need to be propagated to the Junk Dimesnion.

SubscriptionStatusSubscriptionStatus

4Contract End

3Contract Cancelled

1Contract...

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?