Viewing 6 posts - 16 through 21 (of 21 total)
That's what I was trying to do but wasn't exactly sure how to code it. But I actually got a better solution on another forum:
Set up a text box in...
August 3, 2005 at 2:31 pm
The average function only returns the average of one particular field against itself. This is not what I'm trying to do.
August 3, 2005 at 1:44 pm
Yes, I've tried that. It's wrong. It averages the total number of credits by the number of events, not by the number of employees. The number is too low because...
August 3, 2005 at 11:35 am
It does, but my understanding is that it averages the sum total of a given field by the instance count of that field which is not what I want to...
August 3, 2005 at 10:40 am
OK, I"m no SQL expert, but I've been tapped by my company to move our CRM SQL database from a primary to a secondary partition on the same server. I've...
August 1, 2005 at 10:57 am
OK, I'm answering my own post, but here's what I did:
Backed up database normally.
ran BACKUP LOG database WITH TRUNCATE_ONLY
ran DBCC SHRINKFILE on logfile
Success!!
July 6, 2005 at 2:43 pm
Viewing 6 posts - 16 through 21 (of 21 total)