ind_lp data looks like:

id   ind_name

1   abc & (11)

2  bglh (45)

3  yyiouiopo(67)

...

UM is the lot many cols

ind_grp

30608,30624,30644,30645

30601,30650,30623,30624,30637,30641

30623,30631,30645

...

Pls ignore the nolock, i will be removing it when submitting the code.

The idea is to do pagination in order by if count = 0 then one column only else paginate.

when i set pagecount/pageindex value >0 it works but fails for 0...

• This reply was modified 3 years, 9 months ago by  khushbu.

I came up with one version so far it works well. Will surely have a look at above suggestion

If( (@Bookingid!='0')  and (@taskid!='0')  and (@userid!='0') ...

yea please ignore the nolock hints. its what developer do and we always omit when we commit.

Attaching Execution plan for one of case

• This reply was modified 3 years, 9 months ago by  khushbu.

yea we are on it for improving /re designing.

Until then is there a way to identify the ask?

As for using IN instead of =, I may have missed at some places which I will correct.

Nested loop is due to joins. Check EP that I just attached

• This reply was modified 3 years, 11 months ago by  khushbu.

Thanks I thought of that. But there are few more differences in where so let it go.

Thanks bunch for all the inputs. Have incorporated many of them still tweaking it

Thanks for your inputs.

Attaching the EP

• This reply was modified 3 years, 11 months ago by  khushbu.

Wow... Thank you so much for such insights.

However, using a hint in the secondary table or in my case on the joining table can still be okay? since all the...

Thats a bad trade off we live in

Isloation is read committed and developers would like to use NOLOCK everywhere. Just needing some references to make my point nolock in delete ...

Any reference link I can refer too and make my point?

Most articles I found were talking about 1 table use.

What if I'm joining on table 2 and using NOLOCK there? Is it good to use? any issue that i can...

yea added that step:

select run_status = @runstatus from msdb.dbo.sysjobhistory jh

inner join msdb.dbo.sysjobs jb on

jb.job_id = jh.job_id

where jb.name = 'myjob1'

and run_status = 1

if @runstatus = 1

update ....

But still it fails.

SQLServerAgent Error:...

Same error on all the databases on same server