virpan_17 (10/26/2010)
I hope that my question is clear.
As mud.
Alright, you have a table. Col1 is varchar with an assumed column indicating level that's calculated by LEN(Col1). Easy enough. Col2 means... nothing, other then a descriptor. So we don't care.
display NEW level 2 nodes on my webpage. NEW means that I do not have them in the table yet but will need to somehow incorporate them.
You find these level 2 nodes from where? We've described one table... well, kinda described... and this record isn't in there. So, where are you getting it from to compare?
After that, you're simply going to check the current table's Col1 (say, with an 'exists' or 'left join') and see if the Level 2's you've got are in the table. Considering you're comparing Varchar to varchar... you don't even care that they're level 2's, except for how you're going to extract them from the source.
I think that will answer your question for what information we actually have. Otherwise, schema and sample data, as seen below in the links in my signature, please. You're trying to be careful and cagey about your actual data and schema in public. I understand. Also understand that vague descriptions get vague answers.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA