Nice, a triple synchronised post. It's a first for me.

Hey Frank, since when are you approving the use a dynamic sql without questionning the design or the task at hand???

That clears it up... obviously works now on another table.

Unless this is for administration work I would suggest you find another way to solve your problem because the use of dynamic sql is strongly suggested againsts in a production...

I know that but this query results in a scan :

Declare @name as varchar(10)

set @Name = 'id'

Select * from dbo.SysColumns where name like @Name + '%'

Nice point... but I'm still not totally sure of what he wants to do.

null = null returns unknown (without returning false, it doesn't return true). So there's just no match found in that query.

well this would do it in this case.. but what are you trying to achieve exactly?

set @MyMin = ISNULL((Select min(Number) from dbo.Fruits), 0)

I can't replicate that index seek here..

Can you post the ddl and some sample data so I can understand what I'm doing wrong?

I was just prooving your point.. you can't have duplicate values on the clustered index...

Hey Frank, do you have a link where I can learn to show more smiley faces than the one I already way too overused (

wow.. thanx for the trick, really gonna be usefull one of these days.

I could post it but it would be in french so I'll pass on this occasion, but I created this little script.

create table #a

(

A int not null

)

GO

Insert into #a (a)...

Yup... we sometimes have huge threads and we have no other choice than to have 'em on difference pages. Also helps to see the sponsors more (hey they got...

Try something like this in the datasource of the textbox :

=DateDiff("h";[StartDate];[EndDate])

then at the bottom of the report you should be able to use sum([txtboxname])

This would look something like this :

Select * from dbo.YourTable where YourCol = '123456f' collate LATIN1_GENERAL_CS_AC