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...

Bingo! I think. Indeed the main offender was checked as an administrator. I did not even think...

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...

In the trigger I am using system_user to capture the user name. Is there a difference between system_user and suser_sname?

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,...

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)))

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...

What *exactly* are you trying to pull out of this string? Do all records have the same format?

Thanks guys.

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...

Do you have a table linking phone number to name?

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...

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...

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...

Thanks Jack. It'll be ugly, but I will work on table defs, sample data, and view tomorrow.