After a first glance at the 250 lines of undocumented code I don't think you'll need a those nested c.u.r.s.o.r.s *cough* at all.

I'm confident the issue can be resolved with...

Ok, based on harinerella great setup for the sample data here's my approach (based on ROW_NUMBER to get numbered list without gaps and a self join to that list):

WITH cte...

Nope, not in the version I checked (will be published...

Did you have a chance to search for the articles I pointed you at?

I'm sure there is a solution that'll exactly match your requirement.

Langston Montgomery (12/29/2010)

---

Excellent! Thank you for pointing me in the right direction. This article does address all my concerns. I did a search on this great site, but I used...

So I guess I have to withdraw my point of view then...

On a second thought, there is one important thing missing: your approval prior to publishing.

rluke (12/29/2010)

---

it will be forced from the website, at least that's what the web developer is telling me, so I'll know that the first digit will always correspond to Auto...

Craig Farrell (12/29/2010)

---

Hey guys. Blogging/articles and the like are relatively new to me, so I'd like your educated opinions on how I should look at this:

http://balapalani.blogspot.com/2010_12_01_archive.html

It's roughly a copy/paste...

Or, to phrase it slightly different:

Wouldn't it be much easier, if the app would send you a separated list of the products checked instead of a binary code? Something like...

How do you make sure the order used for the binary coding will ALWAYS match the order in your db?

Something like this?

DECLARE @xml XML

SET @xml=

'<root>

<id>2983</id>

<Area>Urgencias</Area>

<Puesto>Enfermera General</Puesto>

<Motivo>Reposicion de personal</Motivo>

<Genero>F</Genero>

</root>'

SELECT

T.c.value('localname[1]', 'varchar(100)') AS element, -- node name extracted from data column (holding NTFRS elements in xml format)

T.c.value('value[1]', 'varchar(100)') AS val ...

Please provide the business rule for your conversion.

How does "F" show up all of a sudden?

Would you mind providing some sample data (including expected result) so w can see what you're looking for?

Your verbal description "leaves some room for interpretation"....;-)

Would it help to see if a table is used in a sproc, view or function?

Then you could use sys.dm_sql_referencing_entities, sys.dm_sql_referenced_entities and sys.sql_expression_dependencies.

This will at least give you the list...

Please explain the business rules on how to get your expected result.

Issues I'm struggling with:

- Item a starts with an amount of 10, but it shows an amount of 5...