UPDATE tbl_leads_queue

 SET lead_status_id  = 7

 WHERE

  parent_lead_id = @LeadID

  AND partner_id = 19

  AND lead_status_id = 3

  AND date_sent between convert(datetime, convert(int, getdate()-0.5)) and convert(datetime, convert(int, getdate()+0.5)) - convert(datetime, '00:00:00.003')

Actually you I can use a select statement to set the value of a parameter variable that is declared locally in the stored procedure.

It just must be SELECT.

SELECT @paramCheckSumNo ...

There are no output only parameters.

OUTPUT parameter is INPUT as well.

Just dare to use it.

OK, start exersise from the beginning.

Being in EM or QA press {F1}.

In Index tab type "output parameters".

Press Enter.

In the list appeared find "Returning values using OUTPUT parameters".

Select it...

Did you hear about the magic and power of knowledge hidden behind the key {F1}?

Probably your function contains SELECT(s) from another table(s) by the value in rows of Table1.

They name it "hidden cursor" and not recommend to use anywhere.

If it's true I would suggest...

SELECT Column1, Column2, case when Column1=’xyz’ then ‘hello’ end as Column3

FROM (

SELECT dbo.MyFunction(a) as Column1, b as Column2

FROM Table1

) dt