The data is kept in a varchar field or in a datetime field??

Also you can check out the convert function in books online.

That would be a nice question to ask the developpement team.  I'm sure there must be a very good reason but I just cannot imagine it for now.  As you...

Sample data and required output would be nice but here's a guess :

WHERE DateCol >= '1998-01-01 10:00:34' AND DateCol < '1998-01-01 23:59:57'

I know you're not counting this, but congrats on the 8000th post .

CREATE TABLE #Demo (ID INT IDENTITY(1,1) NOT NULL)

Insert into #Demo DEFAULT VALUES

Insert into #Demo DEFAULT VALUES

SELECT * FROM #Demo

DROP TABLE #Demo

Sql server stores the data exactly as it should.  18 numerics, 4 of them decimals.  It also sends out the data in that format as it should also.  From there...

I would like to but I'm a little sort this year... and I can cam up with a few Ks this week alone so I'm working this year.

It's the 2nd time you post that question. Looks like you didn't get much help last time.  What I'm proposing is you change something in the question.

1 - Dump the...

I'm sure we can figure something out.  Can you tell us exactly what you are working with (DDL and sample data) and what you need (sample output) and we'll see...

I'm not trying to say that this was what happenned.  I was just clarifying Jeff's pointof you which I totally agree with (already lost the count of days I lost...

Yves the point that Jeff is trying to make is that when someone cross-posts, you dilute the help.  Imagine someone spending 1 hour working on your problem and then finding...

Let's assume this scenario :

SELECT COUNT(*) AS Total, SUM(Col1) AS SumCOL1, SumCOL1 *1.0 / Total AS Avg

FROM dbo.YourTable

As you stated, the columns SumCOL1 and Total do not yet exist neither...

Can you give us more details on what you need?

From what I understand, you are asking us how to program in sql server.  And that subject is way to broad...

Thanx for the info.  merry xmas to you to!

The problem has never been selectivity... I'm still wondering how the heck the server will be able to do a seek on a search like this one :

WHERE(

Oct_1 =...