Here's an option:

SELECT *

FROM #NoShow ns

OUTER APPLY( SELECT TOP 1 fa.ApptDt

FROM #FutureAppts fa

...

If you don't intend to return it, why are you including the SELECT in the code?

Jason A. Long (9/22/2016)

---

I like Luis' approach better... The one thing I would add is code to drop the existing function if it exists...

...

SET @FunctionSQL = 'IF OBJECT_ID(''[dbo].[itvf_Model_Name_Compare]'', ''IF'') IS...

J Livingston SQL (9/22/2016)

---

I am just being curious.....

OP said

....

I have 2 tables and I am attempting to match models. (they are described differently in both tables).

IPHONE 6S ROSE 64GB SGL...

I was curious on my previous idea, which seems to be working fine. Although, with more time, I would improve the code.

CREATE TABLE ReplacementCodes(

type_priority int,

...

Jason A. Long (9/22/2016)

---

One issue that I would take with Sergiy's suggestion is that it can't be used in an iTVF. The resulting function will either be a scalar function...

You've got two great options here. If by any way you get an option of using dynamic sql, please avoid it unless you plan to go unemployed.

The splitter that Jason...

Sergiy (9/21/2016)

---

Be aware that conversion of varchars to datetimes by style "120" is locale dependent.

On different server settings you may get different results:

SET DATEFORMAT DMY

SELECT CONVERT(VARCHAR(20), CONVERT(datetime,CAST('2016-08-10 05:29:27' as datetime),112),...

Interview question?

Ken McKelvey (9/21/2016)

---

As mentioned, this is an horrible design.

If you have to live with an app which uses it, I would alter it so the parameters are logged and a...

My code has no errors. I tested it before posting.

I still have no idea on what you want to return. You're asking to return the same values that you're entering...

jasona.work (9/21/2016)

---

I have had a topic resurrected from the dead!!!

I am now a member of that elite group of "dead topics revived!"

Noticed the email alert that a reply had been...

Your code makes no sense.

Why are you concatenating row counts? You'll end up with a number that means nothing. You're also not telling what are you returning. You mention that...

It's not appending zeros, that's just the way it displays the value stored. Datetime is stored as 2 integers combined in an 8-byte value. One integer is used for the...

Use the maxerrors parameter (-m) with a large value to catch the bad rows in an errorfile defined with the parameter -e.