850 reputation
1020
bio website
location New York, NY
age 37
visits member for 3 years, 8 months
seen Jun 3 at 13:53

Apr
16
awarded  Popular Question
Mar
6
comment incorrect value from SUM Function
@ypercube - Thanks. I'll read up and correct my ignorance.
Mar
6
comment incorrect value from SUM Function
@ypercube I don't understand. Why would a float data type all of a sudden cause sql to incorrectly add the values?
Mar
6
asked incorrect value from SUM Function
Mar
1
awarded  Yearling
Feb
14
awarded  Popular Question
Feb
4
comment linked server hanging
Sorry I should have guessed that. It's something I hadn't thought to try but I can't take that db offline during regular hours. Thanks though.
Feb
4
comment linked server hanging
Unfortunately the linked server doesn't seam to like that command. I get an error: User does not have permission to alter database, the database does not exist, or the database is not in a state that allows access checks.
Feb
4
revised linked server hanging
added 125 characters in body
Feb
4
comment linked server hanging
+1 as that's an excellent reply unfortunately though not the answer. I have no msaccess processes open. I do a copy of the db down to my location which ensures the SQL Server is the only connection.
Feb
4
asked linked server hanging
Jan
29
comment unclear SQL Server Issue
Maxdop is set to 6. The network admin said that he didn't see anything in the windows logs. I'll have to find the cluster logs. I'm not certain if those were checked.
Jan
29
revised Get maximum number with combination of columns
realized it needed an order by for clarity
Jan
29
answered Get maximum number with combination of columns
Jan
29
asked unclear SQL Server Issue
Jan
13
awarded  Popular Question
Jan
10
awarded  Notable Question
Nov
5
awarded  Popular Question
Oct
2
awarded  Notable Question
Oct
1
accepted select row data as column list