All the parts of the body were trying to decide which one would be the boss. The brains said "I do all the thinking so I should be the boss"....

Not sure I see any value from this. Also if I let me SQL servers tweet, the next thing you know they'll want their own Facebook pages and I'm not...

I live 8 miles from work and bicycle to work 2 or 3 days a week. When I moved to this state I waited until I found my job then...

Typically I eat alone and browse online news/sports. It's a quick break from work. Occassionally I'll eat with others but that usually takes longer and distracts me more from work...

1. Yes Navy boot camp San Diego 1978.

2. If the cost were reasonable then maybe. However, calling it a boot camp might not work for many. many of those...

We are covered by HIPPA, SOX, CARF, and PCI compliance so adding SOX was not a big deal. My IT dept is also part of an annual SA94 accounting audit...

We hired someone for IT help desk and within the first two weeks he told me:

1. He had a box of network cables from previous employer

2. He had network equipment...

We run all our backups daily to tape and keep some tapes offsite. Would love to have disk storage but not in the budget. I do keep 3 days of...

Yes, the 4 year sentence is harsh; I've seen armed robbery suspects get less time. But, Childs had no right to hold his company, the city, hostage to make them...

I always try to find at least 3 people recommending a particular solution before I consider it a possibble fix. And then I check with the experts I've found in...

It's nice to know things, but far more important to be able to find the information when needed. If I knew everthing about SQL I wouldn't need you guys. Fortunately...

Steve,

I agree, tape backup is still a requirement for us. We are a non-profit and disk backup is too expensive for more than a few days worth of data. I...

Eugene,

Your CTE code worked very well. Thanks

Eugene,

Sorry, I was in a rush and forgot about the string issue. The BSDONRTE is normally 0 except one row for each EMPLOYID. My goal is to make each BSDONRTE...

Wayne,

Here's the data (insert statements) you requested. I only supplied data for the fields that are applicable as the rest of the fields have no impact.

INSERT INTO [Test].[dbo].[UPR00400] (EMPLOYID, PAYRCORD,...