I have tried that I'm still getting the same error: Error converting data type varchar to int.

I don't know how many digits will tester input, But I wanted to code it that if they input anything more than 9 digits it shud throw an error.

I have but bigint only takes 19 characters.

declare @CompanyName Varchar (20)

set @CompanyName = '2-G9BF'

SELECT PolicyID, Client_Full_Name

INTO #Stage1

FROM DWH.dbo.dim_PolicyWhosWho WITH (NOLOCK)

WHERE IFA_Company_ID = @CompanyName

AND Master_Client = 'Y'

SELECT PolicyID, Client_Full_Name

INTO #Stage2

FROM DWH.dbo.dim_PolicyWhosWho WITH (NOLOCK)

WHERE IFA_Company_ID = @CompanyName

AND...

My charge amount need to cater for both "Then" and "Else", my "else" returns string hence I cast it as varchar. that code so far is working but I need...

Thank you

I changed it my code to

CASE

WHEN SP.IFA_REMUNE_TYPE = 'COMMISSION' AND SP.CHARGE_TYPE IN ('SIC','ANAC')

THEN Sum(CASE WHEN CASH_FLOW_NAME='PR_INITIAL_FEE' THEN CAST((CFH.VALUE/100)AS VARCHAR(16)) ELSE 0 END)

WHEN SP.IFA_REMUNE_TYPE = 'FEES' AND SP.CHARGE_TYPE IN ('SIC','ANAC')

THEN CAST(convert(varchar(10),...

I have already figured that one out, so I have

HAVING SUM(ISNULL(BF.GLOBAL_FEE_TAKEN, 0.00)) < SUM(ISNULL(BF.FEE_AMOUNT, 0.00))

Thank you.

How do I then filter with values where [AmountPaid] is less than [RequestedAmount]

So then, I have a situation where I have 10200 < 32700, why don't I get both value?

I changed ny code to

,[SwitchValue]= SUM(MB.TOTAL_AMOUNT)

,[RequestedAmount]= SUM(BF.FEE_AMOUNT)

,[AmountPaid]= SUM(BF.GLOBAL_FEE_TAKEN)

to I get the NULL values where I was getting Zero values, so it was due to ISNULL

[RequestedAmount] [AmountPaid]

32700 ...

Can I clarify my problem

My Aliases returns just one values, of which that's what I am expecting, so I need to take just those values and compare them and return...

Below is my store proc, all the information above has to be part of my where clause according to the requirements.

ALTER PROCEDURE [dbo].[prc_TopUpCancellation_xml]

@ApplicationID VARCHAR(10)

AS

SELECT

Application_Id

,Policy_Id

,Date_of_Disinvestment

,Original_Investment_Value

,Payout_Value

NB. now there...