silverbullettruck (2/2/2016)

---

Can we push the reset button? I think I derailed people by mistake. Here's a smaller set of data and a before and after of the result...

to pile on with the confusion if I may

what results required for this set?

CREATE TABLE #Test (

RBR VARCHAR(3) NULL,

Attribute VARCHAR(10) NULL,

Value VARCHAR(2)

)

INSERT INTO #Test VALUES ('ONR','XLOC','ML')

INSERT INTO #Test VALUES ('ONR','XLOC','MS')

INSERT...

just for fun......is the following a correct answer ??

CREATE TABLE #Test (

RBR VARCHAR(3) NULL,

Attribute VARCHAR(10) NULL,

Value VARCHAR(2)

)

INSERT INTO #Test VALUES ('ONR','XLOC','ML')

INSERT INTO #Test VALUES ('ONR','XLOC','MS')

INSERT INTO #Test VALUES ('ONR','XLOC','ML')

INSERT INTO...

Looks like Jacob bet me to it....was going to ask same question.

I am also wondering what business requirement you are trying to answer.

with possibly unlimited attributes each having unlimited values.....what...

is this "your" table design.....can you make any changes to it?

going back to your original post...what results are you expecting from such a scenario as the following?

RBR Attribute Value

------- ----------...

ok...so can I assume as well as duplicates that each LOB/Attribute pair can have 1 to...

have...

did these responses answer your question?

http://stackoverflow.com/questions/35123166/how-to-list-code-in-2-separate-columns-using-a-sql-query

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/f6a69966-e2f1-4ddf-9772-d05ea5e9c9f0/how-to-get-salarycode-in-seperate-columns-using-sql-query?forum=transactsql

suggest you give us sample data and expected results.....we will all be on the same page then 🙂

http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

Hugo Kornelis (1/31/2016)

---

The original post appears to be back, but the reply I had already posted is still missing. And so are the two replies posted later (that I did...

Hugo Kornelis (1/31/2016)

---

Hmmm, that's strange. I got email notifications about new posts to a topic that I previously contributed to, but when I click the link I get an error...

ok...but,...

Jeff Moden (1/30/2016)

---

Hugo Kornelis (1/30/2016)

---

The problem is, as long as there is as much as a single person on the forum who just posts some random code that appears to...

yb751 (1/29/2016)

---

This is an example on how you can do it using a crosstab.

DECLARE @myTable TABLE (ID INT, Name VARCHAR(10), Value VARCHAR(20))

INSERT INTO @myTable

VALUES

(1, 'user', 'MYS12345'),

(2, 'user', 'MYS12346'),

(3, 'user', 'MYS123435'),

(4,...

Luis Cazares (1/29/2016)

---

J Livingston SQL (1/29/2016)

---

Hi Luis......why not just use this instead??

SELECT...