Only pitfall that I can see is.. IF you need to keep information for 7 years I would ensure that your media:

1.  Was not overwriteable

2.  Was stored someplace safe

3.  Was...

Of course you will need to add

HAVING InterestInMen = TRUE

  AND LikesMe = TRUE

  AND ....

Also I would just try enclosing your statement inside the parens that David provided.  I think that is the trick and not the alias...

Ok.

IF it takes 6 hours to load the data from EACH TZ and you start each at when each reaches midnight you start from 00:00 > 03:00 (assumption AK and...

One of the features of SQL 2K5 is to be able to use the above SELECT TOP @N FROM ... type syntax

1.  How long does the data load take?

2.  When are users in the system?

3.  When is your maintenance/down time during the day|night?

4.  Is it realistic to load data during the...

The problem is that you are attempting to use the VARCHAR variable as a table.  You can either A.  Change to a table variable (see BOL) or B.  Change the...

The problem is that you are attempting to use the VARCHAR variable as a table.  You can either A.  Change to a table variable (see BOL) or B.  Change the...

And the winner of spending TOO MUCH time thinking about this is GPF2^192 

100% agree with Noeld.

How we do it.

All code is developed in DEV.

Code checked in to Harvest (Like SourceSafe but ....)

When all code is ready to "promote" to TEST we develop...

Having an INDEX on a column where you have only 2 different values really won't buy you much.

What you may want to consider is something like

IF EXISTS (SELECT * FROM...

It is possible.  You will need to add a final step to the job to fire off xp_sendmail.  See BOL for information about it and how to set it up...

How bout

SELECT TOP 1 FROM DatingPool WHERE Quality = 'Perfect' AND Compatibility = TRUE

#1.  you need to put [Edgars test].dbo.

#2.  In future I would not allow developers (or whomever) to create objects with spaces in them for this reason... (Tables, SPs, columns, etc...)

Ahmed,

You can find more information about UDFs in BOL (Books online), here at SQLServerCentral.com, on the web etc..

Basically you create a FUNCTION that can accept parameters and RETURNS a...