Definitely do not need a cursor for this.

declare @ProcessingDate date = '17-May-2012'

PROCESSING_DATE > dateadd(d, @ProcessingDate, -1)

and PROCESSING_DATE <= @ProcessingDate

If that doesn't point you in the right direction, take...

scottichrosaviakosmos (8/10/2012)

---

For those of you who have not understood my question. In one line , I have to do a data migration and have to find the child who have...

Borrowing from the fine example Luis provided this produces the results you are looking at least with the sample data.

SELECT child.LotID,

child.Parent,

isnull(CASE WHEN LEN( child.VBS) > 0 OR LEN( child.MOL)...

Woohoo!!! Vacation starts in about 7 minutes. Meeting my wife's parents, her brother and another close family friend for a long weekend in Chicago. 16 people in all. If you...

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...