Also, you may want to be sure to read this: How to Make Scalar UDFs Run Faster (SQL Spackle)[/url]

Here are two more choices, one a scalar function and the second an in-line table valued function.

create function dbo.scFirstBusinessDay(

@YEAR int

)

returns datetime

as

begin

declare @FirstDay...

Mordred (8/1/2012)

---

Lynn Pettis (8/1/2012)

---

Mordred (8/1/2012)

---

I just had some IT guys look at this but they are unsure as to why it is all-out missing. Another problem is that there...

Please don't double post. Please post replies here.

Mordred (8/1/2012)

---

I just had some IT guys look at this but they are unsure as to why it is all-out missing. Another problem is that there aren't any SSIS...

What would you expect for a startdate = '20120201' and an enddate =...

Evil Kraig F (8/1/2012)

---

Lynn Pettis (8/1/2012)

---

Evil Kraig F (8/1/2012)

---

GilaMonster (7/31/2012)

---

Vacation! Mine! (no, you're...

CELKO (8/1/2012)

---

A useful idiom is a report period calendar. It gives a name to a range of dates.

CREATE TABLE Report_Periods

(report_name CHAR(10) NOT NULL PRIMARY KEY,

report_start_date DATE NOT NULL,

...

Evil Kraig F (8/1/2012)

---

LOL! ...

morepainot (8/1/2012)

---

Lynn Pettis (8/1/2012)

---

Looking really good. You are on the right track for what you need to accomplish. I like the code you are writing, it is well...

Have you considered something like this:

...

left join dbo.A06_AccountSalutations a06

on (a01.FamilyId = 0

and a01.AccountNumber = a06.AccountNumber)

and a06.SalutationType = 'FORMAL')

union

...

left...

MarbryHardin (8/1/2012)

---

Scott D. Jacobson (8/1/2012)

---

MarbryHardin (8/1/2012)

---

Yes, that's my point. Between does not logically imply a comparison order, but SQL Server imposes one.

And consider if you want to supply variables...

One question, do you need to report the error messages recorded if you enter the CATCH block?

Looking really good. You are on the right track for what you need to accomplish. I like the code you are writing, it is well structured, easy to...

Also, this code is not what you should necessarily use directly. It should probably be extended and expanded to make use of your logging tables, etc. It is...