Take a look at the following code that can demonstrate a technique that uses an auxiliary table of numbers:

-- START WITH A TABLE OF THE NUMBERS FROM 1 to 200

SET...

I'm glad you were able to figure it out. I was having trouble understanding why you needed a not equal relationship, as I would have thought that any...

Leave the parameter as an integer, and change the query to check for:

QExpiry.FieldName <= DATEADD(d, @DateOffset, GETDATE())

You should be able to have this work in both locations.

Steve

(aka smunson)

:):):)

Here's the help on the "freetext string" that goes into the FREETEXT function, which explains about quoted strings:

freetext_string

Is text to search for in the column_name. Any text, including words,...

I need to know more about how you plan to keep track of what options have been selected. Are you updating any permnanent table with this information? ...

I saw similar things happen with Excel imports in SQL Server 2000, where if the data in the first several rows LOOKED like a particular data type, a row far...

Hmmm... it appears I'm way behind on information on memory capacity and the ability to get past the 4 GB addressing limit of 32 bits. Can anyone...

I'm not familiar with the term BCP, but given that temporary tables are generally attached to the session that creates them, I'm thinking we need to know more about why...

Yes, Jeff... you're quite right. Being a newbie to both SQL Server 2005 (although an oldie to SQL Server 2000) as well as this forum, my excitement...

Umm... I may not be recalling this correctly, but I haven't seen anyone ask what Server OpSys is in use, and I did see the indication that SQL Server is...

My thought process says when there's no map, make one. Since you appear to be looking at dealing with the Front End, is there any chance you can...

There is a way to do this without sorting. I decided to try using REPLACE and ISNULL and an intermediate CTE, with a source table that has all...

If it helps any, the PIVOT operator uses an aggregate function to consolidate information from a given column, based on possible values of a 2nd column. For character data,...

Have you considered the PIVOT operator? SQL 2005 provides this rather convenient method to convert rows to columns (and UNPIVOT to do the reverse). As an...