Can you elaborate?

Thx.

Is there any easy way just to skip those records rather than return Null?

THx.

Looks good, easy there an easy check to eliminate:

Divide by zero error encountered, and order by high to low %?

Thanks again.

• This reply was modified 3 years, 8 months ago by Bruin.

How do I create the 3rd field which would be a percentage(difference) from col1 and col2?

thx

Thanks for replies and suggestions... after some more research one table was indexing almost all fields. and was updating those during process. Changed table def and that seem to fix...

The code is vendor code looks like Inline sql not stored procedure from my analysis, and Indexes seem inline>

Thx.

Thanks for that clarifications on the query I was using....

It's not a wait in the top 10.

#1 is SOS_SCHEDULER_YIELD 55.86

I'm trying to determine that wait type is something that is hurting SQL process performance .

I looked at that:

Description:

This wait type is when a thread is switching to preemptive mode while allocating memory. The preemptive switch is so that the code being executed does not have...

Do you mean where it's getting data from quality and quality_history ... the history part was added but currently that table is empty..

Could you provide the example crosstab..

Thx.

Yes collation fix helped...

"Second, look at the stuff in the SELECT list and FROM clause... basically, it's all a repeat of the same thing with a different qualifier.  That's a...

Big improvement, do you see anything else that could be tweaked?

Many thanks for suggestion.

I choose the single table solution.

Many thanks for replies and suggestions.

my reply must have go t lost...

The Data will increase and don't have to tie up any Network Traffic, so the route of csv would be I could zip the...

Thanks for replies...

Yes it's SQL to SQL, and no ETL on the data from export to import.