g.britton (8/14/2015)

---

Yes, well the quote from BOL is of course correct. It states in essence that you *can* insert rows where the aggregate data length exceeds 8060 if some...

Me thinks it has something to do with how SQL Server is trying to store data during the insert. From Books Online:

Large Row Support

Rows cannot span pages, however portions...

tjs8984 (8/14/2015)

---

Hello, All,

Thank you. I am overwhelmed with the expeditious replies. This was just a sample data set to get an idea multiple records that are being retuned. ...

Alvin Ramard (8/14/2015)

---

Lynn, as far as I can tell, your script will work as long as the row for PercentFullTime = 1 is the same rows as AnnualizingFactor = 2080....

Alvin Ramard (8/14/2015)

---

Lynn Pettis (8/14/2015)

---

Something like this:

declare @TestTable table(

EEID int,

Name varchar(64),

AnnualizingFactor int,

PercentFullTime decimal(3,2));

insert into...

Something like this:

declare @TestTable table(

EEID int,

Name varchar(64),

AnnualizingFactor int,

PercentFullTime decimal(3,2));

insert into @TestTable

values

(1,'Marvin, Leo',2080,1 ),

(1,'Marvin, Leo',1640,.60),

(2,'Doe,...

Luis Cazares (8/14/2015)

---

Lynn Pettis (8/14/2015)

---

True, but not every RDBMS implements them either. What good is...

Luis Cazares (8/14/2015)

---

Lynn Pettis (8/14/2015)

---

g.britton (8/14/2015)

---

to get enough...

g.britton (8/14/2015)

---

to get enough numbers to handle large...

True, but not every RDBMS implements them either. What good is a standard not used?...

odeddror (8/14/2015)

---

All I want is to count actual column count per all tables (and schema too)

row count is sometime can be misleading (nulls, 0's or ' ' spaces)

Your sproc...

What exactly are you trying to accomplish with this code? What are the expected results?

Jack Corbett (8/13/2015)

---

Lynn Pettis (8/13/2015)

---

Jack Corbett (8/13/2015)

---

Lynn Pettis (8/13/2015)

---

Okay, the PASS Conference is October 27th through October 30th (not currently registered for any pre-cons). I'm...

SQLRNNR (8/13/2015)

---

Lynn Pettis (8/13/2015)

---

Okay, the PASS Conference is October 27th through October 30th (not currently registered for any pre-cons). I'm thinking I should fly in on the 26th and...

Jack Corbett (8/13/2015)

---

Lynn Pettis (8/13/2015)

---

Okay, the PASS Conference is October 27th through October 30th (not currently registered for any pre-cons). I'm thinking I should fly in on...