My apologies to you Noel for not paying closer attention to FHanlon's solution....now that you point it out it should have hit everyone in the face that the max (or...

Just for the fun of it.....

My guess is that fhanlon has it right!

It was posted here wasn't it ?!

Remi - I don't know if you do this already but you should start submitting scripts to scc.com so they can include it in their knowledge base for ready reference!!!

finding it difficult to follow your logic, but you could do something like this:

If(Parameters!Location.Value > "") then

if(Parameters!DateRange.Value > ""

select * from myTable

where myLocation = '"...

You may also want to try...(I can't test this...)

SELECT x.Category, x.COUNT(*) AS TranCount, ((SELECT COUNT(*) FROM TableName x2 WHERE x.Category = x2.Category GROUP BY x2.Category) * 100/ (SELECT COUNT(*) FROM...

You could maybe put this in a procedure (definitely easier) & get the count(*) first...

Declare @TranCount Decimal(10,2)

Select @TranCount = count(*) from TableName

Select (count(*) * 100)/(@TranCount ) As Percentage from TableName

Group...

Remi - is "see hold hold something in" another famous American quote or a typo ?! Now I don't know with you anymore!

<;-)

I know how to get a computed column -

"SELECT syscolumns.name FROM syscolumns

JOIN sysobjects ON sysobjects.id = syscolumns.id

AND syscolumns.iscomputed = 1 AND sysobjects.xtype = 'U'"

I'm sure somewhere in the information...

You tell him Noel - I've been carefully NOT saying what I really want to.....<;-)

Remi - this may be another moo point, so don't worry too much about it!

As long as you're not referred to as a "simpleton" everything's ok! <;-)

sql server forces windows authentication only when users don't have valid logins in the server! Check the user logins properties first....

btw - are these users outside the local network ?!

dc - I feel as vehmently as you (splly. since everyone is entitled to "your" opinion) about sql_variant and obsessively compulsively design my databases to store data in exactly the...

Aruram (btw - my last name is left(4, yourname) <;-)

What a wonderfully diplomatic response!

Remi - Yes, I did understand your flag system...you type too fast - "moo(?)" point - kinda...

But if it's only one or the other it can always be just Y for year and whatever else you want for full DOB (take your pick - "D", "N"......)