...and also look at CONTAINS.

You might also look into CONTAINSTABLE in BOL. It's a little more complicated, but I'd be willing to bet more flexibile and faster.

Peso beat me to it. 😛

What constitutes SIMILAR?

I'm thinking more of something that can be used to verify dynamic sql before running it within an sql procedure that builds the dynamic sql.

Another way (less keystrokes) just multiply one side by 1.0

ISNULL(DROPPEDCALLS.Dropped, 0))/(Count(History.HistoryID) * 1.0)

There are an unlimited number of ways to answer this. Now, when I started out years ago I created a Chess database with all of the procedures to play a...

Your way or create a function to do it.

Search this site for a split function.

You could call it an oilPrice table. :hehe:

😛

I was on the run to the North Pole mentioned here .. http://en.wikipedia.org/wiki/USS_Silversides_(SSN-679)

Now that was fun!

yeah, I got burned by that a few times before I started checking... LOL 😀

Sorry RBarry, but this is the SQL 2000 forum. ROW_NUMBER() isn't supported in 2000.

this solution will work though ...

DECLARE @students TABLE (student VARCHAR(20), attendDate DATETIME)

INSERT @students

SELECT 'student1','1/1/2008' UNION

SELECT 'student1','2/1/2008'...

First we place a unique field on your table. This allows us to join it to itself for the update. We use ROW_NUMBER and PARTITION BY to get the numbers/results...