Sorry, for a COUNT(), what about:

SELECT 'SELECT COUNT(*) FROM ' + SYSOBJECTS.NAME +' WHERE ' +SYSCOLUMNS.NAME +' <''19000101'''

FROM SYSOBJECTS,SYSCOLUMNS

WHERE SYSCOLUMNS.XTYPE=61 AND SYSOBJECTS.ID=SYSCOLUMNS.ID AND SYSOBJECTS.TYPE= 'U'

ORDER BY SYSOBJECTS.NAME

Quick and dirty I would copy the results from

SELECT 'SELECT '+ SYSCOLUMNS.NAME +' FROM ' + SYSOBJECTS.NAME +' WHERE ' +SYSCOLUMNS.NAME +' <''19000101'''

FROM SYSOBJECTS,SYSCOLUMNS

WHERE SYSCOLUMNS.XTYPE=61 AND SYSOBJECTS.ID=SYSCOLUMNS.ID...

Here you can find some links, that might help (don't worry, they are all in english )

http://www.insidesql.de/component/option,com_bookmarks/Itemid,42/catid,26/

Anyway, glad you didn't say, it's a quote by Ron Soukup 

What you've seen from PW is a SET-BASED solution to your problem.  A real world comparison to a CURSOR-BASED solution (which you started off looking for) is the comparison of...

Bear with me. I'm not familiar with vbscript. How can I get this to run?

And, do you mind me, hosting it on my site?

Do you want to tell your boss, that this solution is not really set-oriented?

After surviving yesterday's obvious brain death, can't resist to post...

Two links I can provide:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;825197

http://support.microsoft.com/default.aspx?scid=kb;EN-US;180500 This isn't for SQL Server 2000

Why a cursor?

If you can post post DDL, sample data and the required output, I'm sure there is a way without a cursor.

I think it will be really hard to measure this. Consider one developer working the whole year on a vital enterprise-wide app that will boost company's internal operations effectivity tremendously...

This is a FAQ that you've asked. You might want to read the articles by SQL Server MVP Erland Sommarskog on his homepage at http://www.sommarskog.se . Especially the one...

Look up BOL for severity levels. Level 20 is explained there.

Next I would search the Google Groups for this error along with the name of Paul Randal. He participates frequently...

On days like these I feel that old !!! Lots of horrible mistakes in my answers, not knowing such things like instant messaging and number crunching at work

Sorry, for editing around today:

CREATE TABLE #temp

(

 c1 DATETIME

)

INSERT INTO #temp VALUES('20050224 12:53:00')

INSERT INTO #temp VALUES('20050224 14:53:00')

SELECT

 REPLACE(STR(CASE

  WHEN datediff(ss,c1, GETDATE())>0

  THEN datediff(ss,c1, GETDATE())/60

  ELSE datediff(ss,GETDATE(),c1)/60 END %...

Now, one thing still puzzles me.

You have to make sure how you will deal with the last day of your search range. Will it get included or not? The...