Viewing 15 posts - 421 through 435 (of 621 total)
I think your problem is in the last line, where you are trying to add the int data type to the rest of the select statement. I think you...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 16, 2008 at 9:14 am
sblock (9/11/2008)
Could these people be a member of SysAdmin or db_owner?
Bingo! I think. Indeed the main offender was checked as an administrator. I did not even think...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 11, 2008 at 11:15 am
Ok, I looked at the audit table again, and found there is another guy who is able to update the field in question. The post about restricting access to...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 10, 2008 at 8:40 am
In the trigger I am using system_user to capture the user name. Is there a difference between system_user and suser_sname?
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 10, 2008 at 6:05 am
I have set up a trigger on the table a couple of months ago, and that is how I noticed the problem. I capture the table name, pk, column,...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 9, 2008 at 2:27 pm
I don't know if it would make a difference, but it seems like maybe you could eliminate the CASE in your select by using ISNULL?
AVG(ABS(CAST(dbo.fn_workdays(h.job_execution_dt,ISNULL(h.mdfctn_dt,l.creatn_dt) AS MONEY)))
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 9, 2008 at 11:04 am
Mh, I agree with evaleah, in that I don't really see any pattern, but maybe there is one there. In any event, there was a guy a couple weeks...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 5, 2008 at 8:32 pm
What *exactly* are you trying to pull out of this string? Do all records have the same format?
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 2, 2008 at 1:28 pm
Thanks guys.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
August 26, 2008 at 11:06 am
I do know that the incument telcos provide this data to third party companies, like 411.com, and CLECs, for a fee. If you are in the US, You might...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
August 11, 2008 at 8:13 pm
Do you have a table linking phone number to name?
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
August 11, 2008 at 2:01 pm
Thanks Jack. I tried it both ways on a file with around 30,000 rows, and no errors either way that I can see, so I will will stick with...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
August 11, 2008 at 11:17 am
Barry, I am truly humbled. When I read your article I felt like the tyke I was back in your "back in the day", with the binky in my...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
August 6, 2008 at 7:00 am
I thought we lost you there. I am not sure if you were talking Greek up there, or Chinese math. I would suggest asking someone who can...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
August 5, 2008 at 1:28 pm
Thanks Jack. It'll be ugly, but I will work on table defs, sample data, and view tomorrow.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
August 4, 2008 at 2:23 pm
Viewing 15 posts - 421 through 435 (of 621 total)