It means that not everyone loves a smartarse.....

Take heart Remi - I'm sure you have the gratitude and admiration of the zillions of people you've helped this past year...who needs...

can you post a sample row and desired MemberSeqNbr ?!

Until someone comes up with a better solution - create a stored procedure to format the next number and insert into table by passing the input service date:

1) Declare variable...

You're welcome! Maybe you can post feedback if this fixes the problem!

Ties in well with the other article on "order by" - despite language issues, the step by step approach with snapshots etc. is very easy to understand.

Paully - Vladan's t-sql is your "elegant" solution....

Hi - came across this in one of my searches.....

**********************************************************

The Oledb32.dll file is NOT upgraded when you upgrade from Windows 2000 to Windows Server 2003?

When you upgrade from Windows 2000...

Use -

WHERE username IS NULL

Have you tried using the dts import/export wizard in Enterprise Manager ?! That should be quickest and easiest.

Great! Thanks for feedback!

This is by no means elegant but since the # of categories is UNKNOWN I cannot think you can avoid cursors.....something like this in a stored procedure/UDF ?!?!

CREATE PROCEDURE Get_Top3

AS

DECLARE...

I hope you can set the datatype to datetime for all your date fields - I don't know how many other tables you are querying but it can really...

If there is a possibility of an empty string in that field then:

SELECT * FROM tblResponses WHERE LEN(Notes) > 0

would work better!

Great!

are the "periodbegindate" and "weekofdate" columns smalldatetime datatypes ?!