shashianireddy (12/7/2013)
the first method is ok but ..... it works only if housenumber is integer only ...it shows error when housenumber mixed wit varchar .............
plz write the code if housenumber is varchar
Please respond to Jeff's earlier post here. He's provided a solution which works well for your given sample data. If it fails with other patterns of house number, then include them in your sample. There's no single algorithm which will work for this.
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]