Unfortunately the lag function is not supported on the servers on site, they have SQL Server 2008.

Any other option please?.

I...

What will you want to do about legal words such as "BOOK", "SEEN", or "ABBOTT"?[/quote]

Even in those legal names repetition will be removed because what matters more is how is...

WHY DO YOU WANT TO DO THIS?

[/code][/quote]

First i would like to thank you for your reply, first time i hear of this LAG function 🙂

This function is needed to cross...

I have written the following code but it has a syntax error that i am not able to fix, not sure if case clause is supported inside CTE or what.

declare...

mister.magoo (10/14/2015)

---

To account for repeated letters, I use row_number() partitioned by letter to assign a "positional" value.

So, for the word "test", the results of CTE "LETTERS1" would be

L P

e...

Thank you very much mister.magoo.

Your solution is great, the problem i had in mine is when a letter was duplicated in one of the words which is S in...

GilaMonster (10/12/2015)

---

nadersam (10/12/2015)

---

GilaMonster (10/12/2015)

---

Jeff suggested temp tables. Be careful with table variables, because they don't have statistics, the row estimations are miles off usually and they can (and do) result...

GilaMonster (10/12/2015)

---

Jeff suggested temp tables. Be careful with table variables, because they don't have statistics, the row estimations are miles off usually and they can (and do) result in really...

Thanks Gail for your reply.

I asked this to be able to decide how will i break my view into parts and use a stored procedure instead.

Jeff suggested taking out the...

Will try that

Thank you very much

Thank you Jeff,

I guess CTE is not the answer to this issue, i will try to look into using a stored procedure instead.

I have a question please related to that.

If...

Never mind i was able to solve it.

Thanks

Again i would like to thank you all.

Jason,

Thanks for the full outer join it reduced the duplication in code and having to insert into table variables, i have applied that.

Chris,

To...

Please check my previous reply above

"No it will return success as order...