Thanks. And the moment where SQL Server might not support this old syntax style might come sooner as one might think.

As for the WHERE clause. AFAIK, is this valid ANSI...

Not sure if I understand completely, but if all you're asking for is to find gaps in a sequence, this is an easy task having a numbers table. I'll use...

Modify your table structure. Sounds like some of the columns are *really* wide. See if this helps explaining http://www.sqlservercentral.com/columnists/sjones/pagesize.asp

If you have AWE enabled, see if this helps: http://support.microsoft.com/kb/838459/en-us

If not, I would contact PSS.

See if these will help

http://www.microsoft.com/sql/techinfo/administration/2000/scalabilityfaq.asp

http://www.microsoft.com/sql/techinfo/administration/2000/rosetta.asp

http://www.microsoft.com/technet/prodtechnol/sql/2000/plan/ssmsam.mspx

http://www.microsoft.com/sql/techinfo/administration/2000/scalability.asp

And as RAID 5 has been...

This is the old JOIN syntax. You better forget about it and SQL Server. Read this http://www.microsoft.com/sql/techinfo/tips/development/July23.asp

FWIW, there are some funny annoyances possible when using ISNUMERIC.

SELECT

 ISNUMERIC('$') AS Money_1

 ,ISNUMERIC('2d3') AS Float_1

 , ISNUMERIC('$+,') AS Money_2

Money_1     Float_1     Money_2    

----------- ----------- -----------

1           1           1

(1 row(s) affected)

Thank you!

Thanks!

Why do you think it's an overkill? If you can do so, I think that is the easiest solution. Anyway, CHECKIDENT won't help you much here, as it will only reseed...

Why does this work? First, we're taking advantage of the fact, that, with respect to our question, both 19000421 and 20050421 are equal. Both will return "April" as...

DBNetGrid is a software that you use to present data from a database in a browser environment. It has not really much to do with a database. And you need to...

btw, here's a nice trick, to get the month name from DATEPART

DECLARE @input INT

SET @input = MONTH(GETDATE())

SELECT

 DATENAME(MONTH,@input*28) AS CurrentMonth

CurrentMonth                  

------------------------------

April

(1 row(s) affected)

Get used to use an indepedent and safe date format. See if these help:

http://www.sql-server-performance.com/fk_datetime.asp

http://www.karaszi.com/sqlserver/info_datetime.asp

I guess you care as much as me about that number.