Brandie Tarvin (7/14/2015)

---

Lynn Pettis (7/14/2015)

---

I know that an OP posted a question with the following error:

Cannot create a row of size 8071 which is greater than the allowable maximum row...

WayneS (7/14/2015)

---

Lynn Pettis (7/14/2015)

---

I know that an OP posted a question with the following error:

Cannot create a row of size 8071 which is greater than the allowable maximum row size...

ramana3327 (7/14/2015)

---

Hi,

I am creating mateialized view but it is failing with error that it can't be schema bound.

The query I am working to create materialized view are having joins with...

Jeff Moden (7/14/2015)

---

Lynn Pettis (7/13/2015)

---

OMG! How does Silver Spoon keep his job? Member of ssc for over 10 years and can't seem to do the simplest tasks without running...

Jeff Moden (7/14/2015)

---

Lynn Pettis (7/13/2015)

---

OMG! How does Silver Spoon keep his job? Member of ssc for over 10 years and can't seem to do the simplest tasks without running...

I know that an OP posted a question with the following error:

Cannot create a row of size 8071 which is greater than the allowable maximum row size of 8060. ...

ChrisM@Work (7/14/2015)

---

TomThomson (7/13/2015)

---

Lynn Pettis (7/13/2015)

---

OMG! How does Silver Spoon keep his job? Member of ssc for over 10 years and can't seem to do the simplest tasks without running...

OMG! How does Silver Spoon keep his job? Member of ssc for over 10 years and can't seem to do the simplest tasks without running to the internet.

You may want something like this:

SET NOCOUNT ON;

create table #test

(id int

,color varchar(20)

)

insert into #test

(id, color)

values

(1, 'blue'),(2, 'red'),(3,'green'),(4,'red,green');

SELECT

T.*

FROM

#test T

...

Eirikur's code is correct. What...

Nope, sorry. I have absolutely no idea what you are trying to accomplish.

I know that place, Kylie and I were there on 3/28/2015. Did you get...

Says we are doing an off-line draft?

I'm in!

Couple of things. First, it would help if you could post the DDL for the table(s) involved, some sample data for the table(s) that is representative of the problem...