Looking at this again I am thinking that maybe...

From your original post:

I need to be able to...

Lynn Pettis (8/9/2012)

---

SQLRNNR (8/9/2012)

---

Lynn Pettis (8/9/2012)

---

< rant on >

Here we go again. Let's berate an OP because of things he/she may not even have any control over. I...

venkidesaik (8/9/2012)

---

Hi All,

This is my Sample resultant Table

1

2 1000

3 2000

4 3000

Now i want to remove if any blank rows are...

Lynn Pettis (8/9/2012)

---

Sean Lange (8/9/2012)

---

So we mentioned the deprecated code but you are still using the "old style" error handling by checking @@ERROR. You should use the newer try-catch construct...

So we mentioned the deprecated code but you are still using the "old style" error handling by checking @@ERROR. You should use the newer try-catch construct instead. It is far...

MysteryJimbo (8/9/2012)

---

Lynn Pettis (8/9/2012)

---

First, you shouldn't use SET ROWCOUNT to control the number of rows affected by your DELETE statement. This functionality has been depreciated and may be removed...

Luis Cazares (8/9/2012)

---

Another option, could be

SELECT ISNULL(NULLIF(fm_clinum, '') + CHAR(10), '') +

ISNULL(NULLIF(fm_contac, '') + CHAR(10), '')

...

Missed that part.

This should do it.

SELECT ISNULL(fm_clinum + CHAR(10), '') +...

I think I would take the ISNULL approach. Something like this:

SELECT ISNULL(fm_clinum, '') + ISNULL(fm_contac, '')

...

FROM ...

I don't know how to capture your table but it seems to me that the best way to solve this is from a policy change. I don't mean to tell...

morepainot (8/8/2012)

---

Sean Lange (8/8/2012)

---

Because you already a print command in your code. In the snippet I provided I replace the exec with print because executing your dynamic code is what...

morepainot (8/8/2012)

---

Sean Lange (8/8/2012)

---

morepainot (8/8/2012)

---

Sean Lange (8/8/2012)

---

morepainot (8/8/2012)

---

Sean Lange (8/8/2012)

---

morepainot (8/8/2012)

---

I have a print command at ever end. When I test the code its kicking back to this part of...

Because you already a print command in your code. In the snippet I provided I replace the exec with print because executing your dynamic code is what was causing the...

morepainot (8/8/2012)

---

Sean Lange (8/8/2012)

---

morepainot (8/8/2012)

---

Sean Lange (8/8/2012)

---

morepainot (8/8/2012)

---

I have a print command at ever end. When I test the code its kicking back to this part of the code saying...