Here's a simple solution that works on SS-2000. If this represents a large table, make sure the TIME column is indexed descending. Pull out the derived table and look at...

There is nothing wrong with what you are trying to do. It is done all the time, say a table has a SentBy and a SentTo column both referring to...

The main purpose of the Julian date (in the old days of IT) was to put the date in an easily sortable form. This was before date and datetime datatypes....

I wholeheartedly agree with using a table to hold the cutoff values. The slight performance hit is well worth the flexibility of the design. However, there are two flaws in...

Here's my version, in the form of a couple of functions. The first, LastSunday, returns the date of the last Sunday of the month passed in.

create function dbo.LastSunday(

...

Agreed. In my situation, all of our databases are back-ends...

First of all, you should recognize that you have, not a one-to-many, but a many-to-many relationship between Vendors and Services, resolved through the intersection table VendorServiceLink. You also have created...

This solution gets my vote. If you have the same code then you must...

Based on the info you have provided, you don't need an INSERT trigger. Your client has a poorly designed table but it is a static table -- the data, once...

Yes, I missed that. When teach posted his answer, I had no sooner framed the question, "Now why did he do it...

What you have described is a M:M intersection table between Subjects and Tests with the addition of the date and result of each test. The restriction that each subject is...

What, and miss all the fun? 😉

Yeah. I have to attend a Sarcasm Management class as part of the terms of my release.

I absolutely agree that...

Yes, thank you, but I've known about Identity fields for, gee, several months now.

Oh,...

An identity column? Why? What purpose does it serve? Under what circumstances would you ever...