Thanks Gail. I suspected that, and thought using a CAST and CONVERT wouldn't be too helpfull either.

If a selection is required on the date part of a datetime field what...

Yes, I hadn't thought about comparing just the date (without the time) - obvious now that someone else points it out! Still an ugly way of doing it though.

Well it's obvious that there's something awry here, as an awful lot of people are getting the same (but apparently incorrect) answer.

What version of SQL Server (including Service packs)...

I've had to butcher it a little to remove any company-sensitive details:

CREATE PROC BrainDonor_Test

AS

SET NOCOUNT ON

DECLARE @rc int

DROP table ##Errors

CREATE TABLE ##Errors(

CC_IDInt,

ErrorVarChar(50)

)

-- Scan for suspect data

INSERT INTO ##Errors(CC_ID,...

Hi cl_see,

I'm in the process of developer a solution similar to your requirements.

I have a user on SS 2000, with no email client installed on the same server and...

Hi Greg,

Thanks for that. I've spent the day looking through the BOL and various other resources and have come to the conclusion that they weren't suitable. Not all of our...

Try:

LIKE 'O[_]%'

If you replace 'Where e_Ina11 Is Null' with:

WHERE ISNULL(e_Ina11,0) = 0

does it run as you expect?

I try to avoid Nulls wherever possible as they can cause confusion.

A good article on...

Another option is the ISNULL function, which I use to remove NULL values from the output.

Thanks Florian, I didn't notice the duplicate posting.

Hi,

Your file, or file sample didn't attach to your message. I've never seen an ArcView file, so if you could attach some data it would be appreciated.

BrainDonor.

Hi,

According to BOL, DataLength returns either an int or bigint depending upon the type of the field it is examining. So what is the definition of 'memTest' and how many...

Hi,

OK, there's something it doesn't like within COBOChanges. Could you post it so we can have a look?

BrainDonor.

Hi Malathi,

The SQL you are running would be of benefit to the rest of us.

The obvious things first though - are you sure that a database of that name exists...

As KK said, I'd change it to insert into a temporary table, and then check that table for the condition that would trigger the alerts you're after.

You could also write...