Thanks Britton, it worked.. Thank You

The following columns are part of the CTE but I have omitted it because the problem where I face the difficulty in merging the SELECT statements into one is regarding...

I am posting the modified code. Sorry for the confusion.

WITH Local_EOL_Dioxin_Statistic_Import_New

AS

(

SELECT

...

Koen. Thanks for your comment.

Please help me in rewriting the query. It is a code optimization comment to rewrite it.

I am now using a SELECT DISTINCT to avoid the duplicate records from retrieving.

I can remove this DISTINCT keyword from the query once the OUTER APLLY is changed to LEFT...

Thanks Koen for that input. Can you elaborate on that point.

How my query can be changed to accommodate this.

Thank You on that. Also how I can modify the part using a CTE where the values from a select statemnt are inserted into the temp table like the one...

Also, have a sql code like a temp table creation and insertion inside the Stored proc, please guide me how this can be achieved using CTE or by any other...

Hi Micky, awesome query, Can you explain how it works. I am a newbie to this.

Query Cost is same for both the queries. It does not involve any table scans in both the queries.

Execution query plan is the same.

What about the performance enhancement when...

dwain, great effort.

can you please help me how you got idea about that the table sacn is three.

dwain, your code is superb one..

Please write the UPDATE syntax also, if want to update the column.

I used the Windings font for the two text boxes in the report and used the following expressions for my requirement:

=iif(count(Fields!Results.Value)=0 OR Fields!FindingsDeleted.Value = 1,chr(0120),"o")

AND

...

I achieved the answer using this way:

SELECT

isnull((

select stuff((select ','+ convert(varchar(1000),auditedAreaDescription) from Local_AuditedAreas LA

inner join Local_Audits LU ON LU.auditIncId = LA.auditIncId and LU.auditSqlId = LA.auditSqlId AND LU.isDeleted = 0x0...

Dwain, nice way of doing it..!!

Is this a kind of cross-tab.??