Sorry I could not be of more help. I had assumed you were asking about a replacement for the ISNULL function.

Another member should be able...

Is there a reason you can not create an index even if only for the life of the query? A clustered index on your date field and non-clustered on...

Did you consider trying the COALESCE function?

COALESCE

Returns the first nonnull expression among its arguments.

Syntax

COALESCE ( expression [ ,...n ] )

Arguments

expression

Is an expression of any type.

n

Is a placeholder indicating that...

XP Pro does support VMWare as well as Microsoft Virtual PC 2004.

Toni

You could create a UNIQUE index on the column and be sure it does not allow nulls. If there are duplicates you would get a message and the...

Hi. Nothing specific I can help you about hardware in the UK. You will definitely want to get a laptop with XP PRO or above O/S...

Hi Jeff. Thank you for the response. I ran the query using the one you had posted in your prior response.

SET STATISTICS IO ON

SET STATISTICS TIME...

Hi Jeff. I was challenged to explore using your method(s) as a less resource-intensive approach to the subquery method of getting the TOP n candidates from a set....

Thank you GSquared.

I have to confess on being a bit behind in reading the articles this week as I just completed, and passed, my certification test for SQL...

GSquared. Can you please provide the preferred alternate to a correlated subquery?

Thanks

Toni

I don't think this would make a difference but it might be worth a try just to see. Agree with Matt that this does sound like just the thing...

Is this what you mean?

declare @temptbl table

(salestype varchar(6), salesprice int)

insert into @temptbl (salestype, salesprice)

select 'cash', 5 union all

select 'cash', 3 union all

select 'cash', 2 union all

select 'cash', 1 union...

If you look up CAST and CONVERT in the BOL, it has a table of date formats. This one will do what you want.

select substring (convert (varchar (10),...

If you are not using SIMPLE or BULK LOGGED recovery models and your processing methods permit, you may want to consider doing so. They will do less logging...

I am not clear on what you are trying to do as to future date. If you want a way to add to months, days or years in...