Joe Celko (5/12/2010)

---

Don't use the race codes table; remove the code from the string and see if it has left-overs:

REPLACE('I', '',

REPLACE('N', '',

REPLACE('P', '',

REPLACE('B', '',

REPLACE ( 'W', '', mutli_race_code),

),),),)...

Maybe the reason you didn't get any reply yet is the way you posted your question.

There are some people around (including myself) that prefer to have ready to use sample...

Answering using...

@mike-2:

the recursice CTE apporach is one possible solution. But as soon as there is a larger data volume to deal with, the quirky update is the better choice (from...

What's still missing is your expected result set based on your sample data.

Your reference to your first post won't help here since there is no way to tell whether you...

CirquedeSQLeil (5/11/2010)

---

lmu92 (5/11/2010)

---

If that's the only...

If that's the only purpose of...

The big question is: TOP 1 ordered by what column?

You should figure out what criteria will define the order to select top 1 and add those as an ORDER BY...

a few things I noticed:

If the columns from_date and to_date contain date values, you should store them as datetime data, not as int.

Based on your description it's unclear how @date,...

Use it like the sample I posted in one of your other threads ("Node.value and insert the result to an existing table").

The...

Actually replacing a c.u.r.s.o.r. with a loop is like choosing pest over cholera...

Based on what you describe you don't need a RBAR solution.

I'm confident Jeff Modens "Running Total"...

My I ask you again to run the code you provided to genarate the test data?

Strong hint (among others):

You have the following statement in your code

INSERT INTO [FIB].[dbo].[HHSReportsData]

...

Please try to run the code you provided to generate the sample data. It won't run...

I don't mind adding a few comment marks or removing commas. But at least the...

Two more things I'd like to know:

1) what is your expected result based on your sample data? and

2) What have you tried so far?

Since this is your third thread regarding this issue I recommend you include the reference to thos threads so you wouldn't have to deal with solutions that would not consider...