@rick, Could you please give pointers on what are the scenarios where we specify MultiSubnetFailover=true? 
@

July 4, 2018 at 5:17 am

#1996279

[font="Comic Sans MS"]It needs to be handled with some manipulations:

with s as (

select Type, right('00' + convert(varchar(2), ISNULL(sort,0) ), (select len(MAX(isnull(sort,0))) from #TEST)) Sort from #TEST)

select CASE WHEN...

Ideally the query should be like this

WHERE ID =

CASE

WHEN @ID >0 THEN @CaseID

WHEN @ID = 0 THEN (RMARequestedDate > (GetDate()- @D))

END

We need to minimize the records on which we are going to apply where conditions

Like:

Case-1: For max datecall, We are going to get only one record. But in ur query...

[font="Comic Sans MS"][/font]

WITH S As (select CONVERT(varchar,Timestamp,101) Dtpart,* from #data)

, S1 as (Select Row_number() over (order by MAX(etotal) ) Rid, MAX(etotal) MaxeTotal,Dtpart from S group by Dtpart)

select

S1.Dtpart,T.MaxeTotal...

[font="Comic Sans MS"][/font]

WITH S As (select max(DateCall) MaxDateCall from tblCallLog where phNu=r.phNu group by phNu)

S1 As ((select @a as status1 union select @b-2 ...

Need to write separate try catch block for each DML statements. So that no error will be skipped.

Is this Left outer join?

If yes.

1. "addr.empid = edu.empid"-----This is join condition

2. "addr. AddType = 2"----This is filter condition

filter condition should not be mixed with join condition. But in this...

You have got the error due to foriegn key constraint....

if u want to just increase the identity value by x for the table having some rows.

then us just to reseed...

Truncate table mytable

go

DBCC CHECKIDENT(mytable, reseed, 50)

go

then try to insert values into the table.

Thanks for the help guys.

I set the named pipe setting and it has started working.....

sql server 2005 standard edition

and version is 9.00.3042.00

Can i have the exact table structures of the parent and child table?