Inline table valued functions are more efficient. Multi-statement table valued functions are...

Avoid that. User defined scalar functions in SQL Server are known for giving performance problems. They're slow and they prevent parallelism.

EDIT: Took too long to reply, I just want to...

I expect that Lynn's option can be simplified without errors.

DECLARE @Sample TABLE(

SomeDate datetime,

HarvestYr int

);

INSERT INTO @Sample

VALUES

...

Change your UNION to a UNION ALL, unless you want to eliminate duplicates.

UNION will need to add a sort which is expensive.

If your queries have adequate indexes, I'd go with...

HookSqlDba7 (6/14/2016)

---

Luis Cazares (6/14/2016)

---

The developer should be able to read, at least in non-production environments to create stored procedures which would be deployed to production to apply a more...

I don't see what's the problem. The developer should be able to read, at least in non-production environments to create stored procedures which would be deployed to production to apply...

Sean Lange (6/14/2016)

---

Luis Cazares (6/14/2016)

---

Sometimes I just want to post RTFA(rticle).

People are given answers with an article that explains the solution, but won't bother reading and keep posting saying...

Guilt

Sometimes I just want to post RTFA(rticle).

People are given answers with an article that explains the solution, but won't bother reading and keep posting saying they don't have the...

angelreynosog (6/13/2016)

---

Hello dears,

Recently it made a change where I work on the database. There are currently 2 database and I have to make an inquiry . Follows , I have...

I wonder what would happen if you find "23 hundred Someplace Rd". That's a real possibility if you have free text fields.

Douglas is right. Even if the definitions are the same, you need to use the defined table-type.

On a different topic, you might want to change your splitter function to prevent...

How are you validating your input? What happens if someone sends "Seocnd"? Would you expect "thirty-five" or "thirty five"?

Be careful as this might be a problem.

A mapping table would be the best option in SQL Server. A function would be an option in a procedural language such as C#.

Steve Jones - SSC Editor (6/13/2016)

---

However, you need to do this in an idempotent way. You don't want to run

ALTER TABLE mytable add mycol int

and there already be a mycol...