I've only read the first two pages so forgive me if I say something that was already said later on.

Some have questioned FK relationships based on performance. Yes, there is...

You can always create a diagram with just the table you want to change. Then when the table is just the way you want it, right click on the white...

Factorials are a perfect problem to use when teaching the concept of recursion. The solution is very simple and the definition is already stated in recursive form! ITRW, it is...

My first programming position was on a DART system - Data Acquisition in Real Time. I got into the habit of squeezing every ounce of speed from the code. Everything...

Sometimes we get data from all kinds of sources that often needs to be converted to a more usable form.

Parsing functions should be a dime a dozen. I would be...

For what it's worth, I just want to add my voice to agree with the others. There are too many ways (user functions, calculated columns) to give your users what...

I...

Here is another function that came out of this particular exercise:

/*

=============================================

Author:

Tomm Carr

Create date:

10/23/2007

Description:

Returns a 1 if the specified...

This is why I defined in an earlier posting that each date was to be considered the beginning of the work day. That way, if the date you are given...

Here is my (hopefully) final submission. The trouble with all the previous submissions (including mine) was that they couldn't handle a few days that went over a weekend. Given a...

If anyone is interested, here is a function that will return a DateFirst-independent value for the day of the week.

/*

Author:

Tomm Carr

Create date:

10/25/2007

Description:

...

Greg Snidow (10/24/2007)

---

For me that is a minor issue, as in my office I think I can get folks to agree on whether to count the first day or not....

Matt Miller (10/24/2007)

---

For what it's worth Tomm - Greg's requirements seemed to be a little different (at least the ones at first), which is why several of the functions...

Wow, really close. It works with positive values for all starting dates. It only fails when subtracting...

Sergiy (10/23/2007)

---

If we compare to mine - then mine is better.

I do it in one go, you do 2 tries.

And my option can be easily converted to set-based version. Can...