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...

Simplest solution:

select patindex('%[^0-9]12[^0-9]%',' ' + @String + ' ')

You cannot use set of values as a parameter for UDF.

t.StudentId is not a value, it's a set of values.

You need rewrite the function to have only @CompanyId as a...

Aaron, your trigger gonna fail of part of RecId from Inserted exist in tblTempCustomer and part does not.

DON'T USE "IF" FOR SETS!

There is "WHERE" clause for this.

Use

UPDATE tblTempCustomer

SET ...

FROM iserted

WHERE inserted.RecID = tblTempCustomer.RecId

select Nbr%100

What about UDF?

dbo.SalesAmount(@CustomerId, @PeriodStart, @PeriodEnd)

SELECT CustomerId,

dbo.SalesAmount(CustomerId, @Today, @Today + 1) as Todays$,

dbo.SalesAmount(CustomerId, @Today - 1, @Today) as Todays$,

dbo.SalesAmount(CustomerId, dateadd(mm, -(Datepart(mm, @Today) + 1, dateadd(dd, -(Datepart(dd, @Today) + 1, @Today)),...

EXEC [dbo].[sp_get_admin_email] @address OUTPUT

What exactly you did not understand in BOL article "UPDATETEXT"?

IF NOT EXISTS (select procedure entry here)

EXEC('CREATE PROCEDURE ....')

Me?

Nothing.

Your question is not about T-SQL.

Supply your algorithm and we will help you to implement it in SQL.

But seems solution is what you need.

Actually, they pay me good salary for solving problems like this.

Including rounding issue in reports.

Will you?

How you string suppose to look if you 1st flight to JFK airport in NY and 2nd flight from another airport?

Should you display taxi travel?

What about indexes on joined fields?

Look on Execution Plan for this query.

It will not work this way.

You will see the code of EM replacement character, not the one has been replaced.

SELECT ASCII(SUBSTRING(<ColName>, <StartPosition>, 1))