It's better to use a view in this case.

Function is just a wrong idea.

NULL just means that there in no corresponding data in T1.

If you have AddressId in table Customers NULL in this field means that there is no address recorded for this customer.

insert into #Who ()...

exec sp_who2 

SELECT .. from #Who

If you adding another field to query with distinct without proper consideration you are probably changing grooping of data accidentally.

GROOP BY will stop you from it asking add the field...

This version makes using of indexes impossible.

So, you need to have

GROUP BY appno,appseq,ledger

in your INSERT statement as well as

WHERE NOT EXIST (select 1 from IX_budget05 I

         where <value for appno> =...

DISTINCT is a simplest case of GROUP BY.

select count(*) from BLacklist

   where CHARINDEX(BlackListResponse, 'crap1 or what ever crap they may send') > 0

So what?

"hire date is less then 90 days from today"

can be easily traslated to:

hire_date < dateadd(dd, -90, Getdate() )

Worst suggestion.

Never do like this.

CONVERT(DECIMAL(19, 2), SUM(op_o.actual_total) )

I would normalize it first and than do the math.

Can you just code what you are asking for?

Look:

"hire date is greater then 90 days from today"

can be easily traslated to:

hire_date > dateadd(dd, -90, Getdate() )

Why to complicate...

UPDATE MyTable

SET ColA = A.ColA,

ColB = A.ColB,

....

FROM MyTable A

WHERE A.ColX = @Value

What's a difference between numeric(p, 0) and integer?

I don't see any except numeric takes more space to store the same values.

If integer is not big enough for you use bigint.

If the...