Can someone explain why the first query I posted didn't work in this context?? I can't reproduce this behavior on my server.

Can't you run this??

Select dtValidDates.txtDate from

(SELECT txtDate

FROM Table

WHERE ISDATE(txtDate) = 1) dtValidDates

WHERE CONVERT(DATETIME,dtValidDates.txtDate) BETWEEN '01/01/2003 00:00:00' AND

'04/30/2005 23:59:59'

SELECT

SUM(CASE WHEN QUESTION1_SCORE = 0 THEN 1 ELSE 0 END) AS Q1

, SUM(CASE WHEN QUESTION2_SCORE = 0 THEN 1 ELSE 0 END) AS Q2

, SUM(CASE WHEN QUESTION3_SCORE =...

It's because the query optimizer is evaluating the between operand first. Try this :

Select dtValidDates.txtDate from

(SELECT txtDate

FROM Table

WHERE ISDATE( txtDate ) = 1) dtValidDates

AND dtValidDates.txtDates between '01/01/2003...

I know.. multiple whitespaces are ignored by the browser..

this query can solve part of your problem :

SELECT

TEST_DATE

, SUM(CASE WHEN QUESTION1_SCORE = 0 THEN 1 ELSE 0 END)...

Yes.

msdb

sysjob*

We well need to see the DDL of the tables to answer this one...

I would normally have a questions table with an answers table. So a simple inner join...

30 triggers on the same table????? what the hell kind of business rules did you have in there??

Too yound : thank God.

Please keep using the sp, dynamic sql shouldn't be used in prodution especially with strings. Read this for more info :

The Curse and Blessings of Dynamic SQL

Update dbo.YourTable SET YourColumn = Replace(YourColumn, '@thewebaddress.org', '@webaddress.org')

Can you debug the proc?

It's impossible to do it in 1 query.

Dim oConn 'can't use as in vbs

Dim oRS

Dim strSQL

set OConn = CreateObject("ADODB.Connection")

set oRS = CreateObject ("ADODB.Recordset")

oConn.CommandTimeout = 0

oConn.CursorLocation = 3 'adUseClient

oConn.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MyDatabase;Data Source=MyDataServer"

oRS.Open "Select count(*) as...