Actually, you only need the NULLIF in denominator:

AVG(ISNULL(F.WinningBid/NULLIF(F.AuctionSellerReserve, 0), 0))

Try making a change similar to the above in your code.

Curious, what is your position at your current employer?

Have you ever installed SQL Server?

You really need to start reading more in Books Online. It is...

Does the following help?

declare @ TimeVal time,

@ TotalTime time; -- spaces between @ and rest of variable names to...

Is my halo getting tarnished by such responses as this?

Since it appears that you are attempting to setup SQL Mail in SQL Server 2000, you need to install a MAPI compliant client on the server. This would be...

Care to share?

See it quite often. Most replies are that it was inherited...

It would help to have the table definition(s) (CREATE TABLE statement(s)), sample data (as a series of INSERT INTO statements) for the table(s), expected results based on sample data. ...

Would be more fun! 😉

tan110 (1/27/2010)

---

its weird, when I run:

declare @ TimeVal varchar(16); -- Added space between @ and TimeVal to get code to post

set @TimeVal = '00.13.00';

select @TimeVal, cast(replace(@TimeVal,'.',':') as time)

declare @ TimeVal...

Curious, the following test code worked just fine on my system:

declare @ TimeVal varchar(16); -- Added space between @ and TimeVal to get code to post

set @TimeVal = '00.13.00';

select @TimeVal,...

As for the date comparision, I'd rewrite the query as follows to allow for the use of an index on creation_time if it exists:

select

*

from

...

Greg Edwards-268690 (1/27/2010)

---

I'm just about to upgrade to SQL 2008 on new hardware too.

Just got the news about 'all they have left is slow SAN space', to which I said...

Crash-course-OJT

Greg Edwards-268690 (1/27/2010)

---

I kind of like the idea of tying SQL Server hardware to a SAN that is tuned to match.

A bit on the spendy side, but see where you...