For max recursion.

I am getting error

The statement terminated. The maximum recursion 100 has been exhausted before statement completion.

My DBA don't allow me to Use this MaxRecursion. I am looking...

I didn't get it.

I need to change always 3 to 2.

Thanks.

That's correct. there is no order I am using view and I have to find out this in subquery inside the view.

Yes,, I checked but it wan't work.

Thanks

OK .. Thanks. Let me try and let you know.

Thanks

Yes.. I got it. I wasn't get answer clear at that time on that threat.

Thanks

Hi,, After doing my best try,

I believe, below query should work.

SELECT o.*,

COALESCE( NULLIF( o.t_wght, 0), x.t_wght,y.t_wght, 0)

FROM [TBRTEK002] o

OUTER APPLY (

...

Hi,

I tried again but I am not to produce result as i expected. Please help me and provide query.

Thanks

Thanks for your reply.

I was doing in different scenario, that's why i remove order by. I knew, order by is used to select top 1 wght based on asc...

SELECT o.*,

COALESCE( NULLIF(o.t_wght, 0), x.t_wght, 0)

FROM [TBRTEK002] o

OUTER APPLY (

SELECT TOP 1 max(i.t_wght) as...

I understood the query but I am not able to return the result. I tried my best to get result. Please help me.

Thank you so much.

It is worked in some condition.

In below condition, it is not working.

t_mcnot_citgt_trdt ...

Sorry.. I have 2014. but server is2008 R2.