You want to have 31 days even for the months that have fewer than 31 days?

Probably the simplest solution would be to build a dynamic SQL statement. You are much more likely to get an optimal query plan, than with what you are trying.

The only reasons for them to ask your salary history are reasons that are not in your interest. They might want to low-ball your salary offer. They might...

I believe that the AES encryption methods are the modern standard for symmetric key encryption, and AES-256 is approved by the US Government for Top Secret information.

270K/sec sounds pretty good.

That means it can lookup 2GB/sec of data pages, so it is capable of fast scans of fairly large tables.

This is the reason that when I join a new company, I go out of my way to learn the names of and be nice to the building maintenance guys,...

You need to understand how NULL works.

The StatusID columns with a value of null will fail this test:

StatusID <> '72HOURRESIGNATION'

Try this:

( StatusID <> '72HOURRESIGNATION' or StatusID is null )

It will obviously depend on the speed of your processors, memory, and front-side bus.

I have seen speeds in excess of 100K pages/sec on servers with fairly average specs. I...

You can trap the error with a TRY/CATCH block, and return the error that you want.

The trouble with checksum is that a difference in the checksum means that the rows are different, but identical checksums do not mean that they are the same.

It is not...

A user defined function cannot use dynamic SQL.

Jeremy (4/7/2008)

---

how about

Create table #t1(col1 int primary key, col2 int, col3 int)

Insert INTO #t1

Select 1,1,1

union all Select 2,1,2

union all Select 3,1,3

Create table #t2(col1 int primary key, col2 int ,...

Date range queries should always be in the form of:

Where MyDate >= StartofRange and MyDate < EndOfRange

Using a function call against a datetime column uses more resources because it has...

Sometimes you just have to do the work. You can write a script against information_schema.columns to generate the code you need.

The following is the general logic you need to...

No, but it should be easy enough for you to...