@Jonathan.crawford, Thank you!

@Taps, Yes we are doing the same. Thank you for your reply.

Regards,

Akash

Hi Vivek,

Thank you for your quick response on the query and efforts. As shown in the diagram, we do not want customer 4 in the output.
Why we...

Here is the execution plan for your reference.

I cannot, due to some restrictions. Can you please suggest. FootNotetext and symbol are varchar columns and all ids columns are of integer type. We are trying to bring...

should i use distinct and remove table valued function. And try to use alternatives of COALESCE.

Hi,

I have changed the query to

SELECTVMI.MeetingID,

VMI.FundID,

VMI.VoteString,

VMI.ClientVoteID,

CASE WHEN ((VMI.VoteString IS NULL) OR RTRIM(LTRIM(REPLACE(REPLACE(VMI.VoteString,'D',''),'N',''))) = '' )THEN 0 ELSE 1 END AS VoteFlag,

VMI.MeetingDate,

VMI.RecordDate,

VMI.CompanyName As CompanyName,

VMI.Ticker As Ticker,

VMI.CompressedName As CompressedName,

VMI.MeetingTypeID,

VMI.MeetingType,

VMI.SecurityID,

VMI.SecurityType,

VMI.VotingPolicyID,

VMI.VotingPolicy,

VMI.CountryID,

VMI.Country,

VMI.Latitude,

VMI.Longitude,

VMI.ItemOnAgendaID,

VMI.BallotID,

VMI.ClientVote AS ClientVote,

VMI.MgtRecVote,

VMI.CompanyID,

VMI.SixDigitGICS,

VMI.SixDigitSectorType

FROM...

What would be alternative for not using functions in where, having and ON clause.

i am using group by to get distinct data.

INSERT INTO #MeetingInformation(MeetingID,FundID,VoteString,ClientVoteID,VoteFlag,MeetingDate,RecordDate,CompanyName,Ticker

,CompressedName,MeetingTypeID,MeetingType,SecurityID

,SecurityType,VotingPolicyID,VotingPolicy,CountryId,Country,Latitude,Longitude,ItemOnAgendaID,BallotID,ClientVote,MgtRecVote,CompanyID,

SixDigitGICS,SixDigitSectorType)

SELECTVMI.MeetingID,

VMI.FundID,

VMI.VoteString,

VMI.ClientVoteID,

CASE WHEN ((VMI.VoteString IS NULL) OR RTRIM(LTRIM(REPLACE(REPLACE(VMI.VoteString,'D',''),'N',''))) = '' )THEN 0 ELSE 1 END AS VoteFlag,

VMI.MeetingDate,

VMI.RecordDate,

VMI.CompanyName As CompanyName,

VMI.Ticker As Ticker,

VMI.CompressedName As CompressedName,

VMI.MeetingTypeID,

VMI.MeetingType,

VMI.SecurityID,

VMI.SecurityType,

VMI.VotingPolicyID,

VMI.VotingPolicy,

VMI.CountryID,

VMI.Country,

VMI.Latitude,

VMI.Longitude,

VMI.ItemOnAgendaID,

VMI.BallotID,

VMI.ClientVote AS ClientVote,

VMI.MgtRecVote,

VMI.CompanyID,

VMI.SixDigitGICS,

VMI.SixDigitSectorType

FROMDbo.[VDSMeetingInformation] VMI...

I have added two more tables which has only 800 Records in it.

Hi,

Please find the attached execution plan and table structure for your reference. After replacing the tabular function, still there is no improvement.

Thanks,

Akash

what if domains are non trusted? just #curious 🙂

Is there any other way?