Guys,

It turns out that we could just write a SQL snippet and wrap up with paranthesis as it is an expression.

Below is working

(select case

when PureYOA = '[?]' then '[?]'...

something like this should work...

declare

@ErrorMessage NVARCHAR(4000),

@ErrorNumber INT,

@ErrorSeverity INT,

@ErrorState INT,

@ErrorLine INT,

@ErrorProcedure NVARCHAR(200)

begin try

begin Tran

.....

...

Has anyone experienced such an issue please?

Hi Adi,

Thank you for your advice. And yes you are right. What I meant was all the columns that in out put list of all columns on join condition.

We are...

Hi,

Thank you for your reply.

It was a backup and restore and part of the migration plan, we've updated stats and rebuilt indexes. This is infact a puzzling bit. It...

Hi All,

Has anyone have idea about this please?

Thanks

Enis

Hi Guys,

I have found what the problem was. This table has 19 non clustered in all of the foreign keys most of which are not even used anywhere. I have...

I have attached the cutdown version of the procedure

Hi,

Thanks for the reply first of all. Also most of the text seems to have been removed from the context. I don't why it happened. This time I have...

Hi Dan,

It is about 1 million. Do you think it would be better I use a temp table.

Thanks

Enis

Hi Gail,

Attached is the new SQL query plan and results seem to be identical that of original query so far.

Performance improved massively by the way. Thank you

Regards

Enis

Hi Gail,

You are absolutely right. I am testing it right now and it looks good so far. It is early stages but it should be fine.

Once the query runs I...

Hi Gail,

That's a very good idea actually. I think it will speed up the query considerably. I am not sure whether the granularity will be lost as you removed a...

Hi Grant,

Thank you for your response.

The idea behind the view was to running one query to bring multiple measures rather than run the same query as many as number of...