There are no infinite situations some are more cumbersome than others but here is what "I" would do.

I will give a list of apporved (locally) codes/Numbers to the senders and create a...

If you are using sqlData Provider I have news for you: Is meant to work with SQL SERVER 2000! when you set the compatiblility level on the server to 6.5...

soundex and difference are functions to help you rank the proximity in pronunciation but I believe that you are following the wrong path!!!

You need to establish a set of rules at both...

Select 10000 + (10*a.n + b.n) as number

into #T

from

(

          select 0 as n

union all select 1

union all select 2

union all select 3

union all select 4

union all select 5

union...

OR if you follow the Trigger idea from Remi the use an INSTEAD OF insert trigger to insert the good rows on the detination table and the bad ones on...

I would suggest that if the number of records is large you should not use cursors, use queries instead to search by column conditions

For example

you can insert in the error table...

I have no clue of what are the rules for zulu time but:

select  replace(convert (varchar(8), @date, 14),':','')

You are aware that you are changing datetime to time only, right?

select convert( varchar(20), cast(9123456.78 as money), 1)

By the way if you are going to use above query just make sure you set up a constraint on EmpID and Date (To avoid the asumtion that the query...

JMeyer32,

You should not feel offended. Remi was really trying to disuade others from pointing you in the wrong direction. I know that sometimes it does not come accross as you expect but I...

>>From within the trigger, execute msdb..sp_start_job <job name>.<<

Please do not do that, because jobs are not re-entrant! In other words when you try start a job from a trigger if...

Cory,

If all you need is a check sum (which I supposed it would be) then 

this is your function:

select checksum(Field) 

or

select binary_checksum(Field)

Ah and my function DO add all numbers!

Remi,

 Good job...

Remi,

For some reason I can't find the link now, [ I'll keep looking ]

The problem is that (depending on indexes and data) SQL...

from your examples I would assume that when you said "computed variable" you are actually saying "computed column" if that is the case then yes you can! if that is...

SELECT txtDate

FROM Table

WHERE

     (case when ISDATE( txtDate ) = 1

          then case when CONVERT( DATETIME, txtDate ) BETWEEN '01/01/2003' AND '04/30/2005 23:59:59'  then 1 else 0 end

     else 0...