If you need a consultant for that long, you need to permanently hire him... or at least give a 18 months contract. There's no point in doing it in...

We didn't think you meant slaves in a bad way... we all know what it is to be "forced" to keep a job. Not the best feeling in the...

We could debate this for weeks (with all the knowlegde of this community), but we don't have the table def so I don't see the point of continuing this discussion...

HTH.

Select left(CodeCol, 2) as CodeType, count(*) as Total from TempTable

Group by left(CodeCol, 2)

I'm gonna say it again :

you need to stop thinking horizontally and start thinking vertically :

Select sum(col1), sum(Col2), datename(m, datecol), ...

from Table T inner join (Select id1, id2,...

I think that the select in the first proc is causing the problem. Try removing the select, then in the if statement put an if exists (removed select stmnt)

One other way to get an estimate would be to send 5k rows then multiple by 100 (or 200 assuming there's more overhead when there are more rows in the...

You can install sql server and do your queries there... or you could simply let access generate the queries with the wizard and ignore its sql altogether.

R u doing...

Isn't it why sql server creates and maintains statistics? I wonder if someone can come up with a sample script to show what really happens.

...untill now

Need anything else?

That's why I gave my first answer as =

but that makes the assumption that the column is a bit... or can only have only 2 values. If this is...

Ya.. we'll do that as soon as we clear our national debt .

Or he posts while he's at work.

BTW if you even plan to use SQL SERVER 2005 you're better off with this solution :

SELECT Table_Name

FROM Information_Schema.Columns

WHERE Column_Name = 'myCol'

Since I hear that direct access to the...