Nice.....

You can really tell that Time has had to deal with this before I share Ryan's sentiment... nice job!

Gail, thanks for the feedback......

I always wait on "Very Urgent" requests like this that have such a simple basis... it usually means that someone is taking an SQL test as part of an interview and,...

Heh... what if there was nothing from yesterday, either?  Peter's solution is good.

But, why is there even a need to check the date?  Tomorrow's news will likely not happen today.

Sorry, I don't know Neetal... I'm pretty much at a loss on this one...

Can anyone else help on this?  I'm neither and sp_oa Ninja nor a mail ninja...

If it was working before, then the devil is in the data...

What creates the IP address on the SMTP Server?  If it's DHCP and someone rebooted it, it may...

Gail,

I know you said you checked, but try this on the table that produces the error...

SELECT *

FROM Test

WHERE AMOUNT LIKE '%[^0-9]%'

Yes, it's possible...

EXEC Master.dbo.xp_CmdShell "DIR d:\path\*.trn,d:\path\*.bkp /s/b"

If you actually want to use the file names, create a table with a nice wide VARCHAR column and do this...

INSERT INTO yourtable (widevarcharcolname)

EXEC...

I absolutely agree... for man-power scheduling purposes, ok... for simple reporting, doesn't matter.

Here's another way to find what the day of the week is without regard to @@DateFirst...

SELECT DATENAME(dw,GETDATE())

Or, you could do this...

SET @variable = ISNULL(@variable,0)

... for inline code, you don't even need to change the value... just use the formula...

SELECT ISNULL(@variable,0)

FROM yada yada

... OR...

SELECT yada yada

FROM wgga...

Thank you for the feed back on your resolution!  It's a keeper...

Shouldn't need to index the view if the underlying tables are properly indexed... indexing a view also requires the view to be schema bound and that all UDF's addressed by...

Guess I'm being a bit picky here... where does @a or @b-2 parameters of the function get used in the function?  I'm thinking the function posted has some other problems......