Viewing 15 posts - 17,941 through 17,955 (of 18,926 total)
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...
April 29, 2005 at 1:30 pm
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...
April 29, 2005 at 12:01 pm
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...
April 29, 2005 at 11:59 am
Select left(CodeCol, 2) as CodeType, count(*) as Total from TempTable
Group by left(CodeCol, 2)
April 29, 2005 at 11:37 am
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,...
April 29, 2005 at 11:33 am
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)
April 29, 2005 at 11:27 am
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...
April 29, 2005 at 11:18 am
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...
April 29, 2005 at 11:16 am
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.
April 29, 2005 at 9:56 am
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...
April 29, 2005 at 9:44 am
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...
April 29, 2005 at 8:04 am
Viewing 15 posts - 17,941 through 17,955 (of 18,926 total)