Again, you...

For better assistance, please post the DDL (CREATE TABLE statement) for the table(s) involved, sample data (not production data) as INSERT INTO statements for the table(s) involved, expected results based...

jonathanm 4432 (5/5/2016)

---

Not getting an error. I am trying to get the if equation to work correctly so that if the average of the sum of the 3 fields is...

jonathanm 4432 (5/5/2016)

---

Ok, so I tried to then do an average but getting an error. Would you happen to know what is missing

select a.[Sales Rep], a.CustomerName as [Customer Name], a.AcctNumber,...

Jeff Moden (5/5/2016)

---

edwardwill (5/4/2016)

---

It's broken so no,...

jonathanm 4432 (5/5/2016)

---

Thank you very much for your help.

I will have to look into that. I only do it to reference the tables using because many of the tables...

TomThomson (5/4/2016)

---

I looked at this before morning cofee or breakfast and decided that I couldn't be bothered to guess the answer before the code was fixed - came back at...

Raghavendra Mudugal (5/4/2016)

---

(EP)Z!!!

No need of STUFF. (very old code)

declare @t table (PersonID int, AreaCode varchar(10), Exchange varchar(10), Root

varchar(10))

declare @t1 table (PersonID int, phone varchar(2048))

declare @pn varchar(2048), @Pid int

insert @t

select 10001,...

Actually, Steve, no one has been asking for their points back. :w00t:

edwardwill (5/4/2016)

---

Ed Wagner (5/4/2016)

---

edwardwill (5/4/2016)

---

It's broken so...

edwardwill (5/4/2016)

---

It's broken so no, it's not...

Wow, you have your own country? Must be awesome!

krachynski (5/4/2016)

---

I can't see STUFF() in here and I'm not entirely sure where it would be used but I can make a decent guess about what the purpose is. I'd...

Could say this is a "May the force be with you" type question.

Do this so many times I didn't catch that the STUFF function was missing. Got it right without it there.