jeganbenitto.francis (12/16/2013)
ChrisM@Work ,Thanks for your reply. I am getting below Error
Ambiguous column name colEEEE .
Without a table name or column names to work with, I made up the names of the columns used in the query. Substitute your actual table name and column names.
Somewhere in my query you will have to name the output column - either the first select as a column alias, or after the table alias.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden