I think I got why we are joining the table using =. Sorry for multiple posts.!

Also, why do we need to do SELECT * FROM dbo.tbTestThree t3 -- Cant I select only the required column and still use EXIST?

Thanks for the help, I recreated the SP with Exist, however, I am not sure why you used this " t2.Account_ID = t.T_Account_ID" in the above-updated query? can you please...

**Function Code**

CREATE FUNCTION [Schema].[fnAuto_Amount_V1]

(

@Cust_ID INT,

@Year INT ,

@Auto_ID INT

)

RETURNS MONEY

AS

BEGIN

DECLARE @ AutoTestP MONEY

DECLARE @ AutoTestC MONEY

DECLARE @Sample_Include_For_TType_123 BIT

Declare @Exclude_For_Trans_Type_123 BIT

IF @Auto_ID = 8 OR @Auto_ID = 123

BEGIN

SET @Sample_Include_For_TType= 1

END

ELSE IF @Auto_ID...

No...they are just to get a few cols data and the tables in this scenario are smaller than 1TB. However, I am stuck with what to choose when dealing with...

The function is being used in Parent SP. When I check the performance of the Parent SP, the function is taking 99% of the time.

Now,  one of the things I...

I tried to do the below and it is still giving error ..  would you be able to modify in the above SP itself?  It will help me understand better.,...