The "best way" was not the accurate way. I ran all three of the options and my own age calculation function. I checked the accuracy of all three and only...

While embedding an insert into a table variable in a transaction is valid and would function, the way it is in the question led me to check it, along with...

My comment on the Financial check is more intent on, how long might this person be around if someone offers them more money, or will they potentially take a second...

For all the years these different types of testing have been going on, these are still very debatable issues. So, no diatribe, just quick answers from a personal view.

Drug Testing:...

Raised, educated and employed in Alaska (with the exception of a one year contract gig in SF Ca) to this day.

Love the place, but the Winters seem to be...

The request would have to be a signed physical document requesting the information, what it is to be used for, and by whom. Also, I would have to seriously consider...

Not sure if this will help, but check the where statement

CREATE PROCEDURE Myprocedure

@newplayerID NVARCHAR(100) = NULL,

@newballID NVARCHAR(100) = NULL

@oldplayerID NVARCHAR(100) = NULL,

@oldballID NVARCHAR(100) = NULL

@newplayerName NVARCHAR(100) = NULL,

@newballName NVARCHAR(100) =...

For the office, I would ask for just one day where people actually listen to each other and hear what is being said. We have a lot of frustration in...

One of the more interesting rationalizations I hear in the government office in which I work is that just because what works in the private sector (planning, project management, communication...

Sorry, I deem coffee a required beverage to operate, and therefore cannot classify it as a snack.

My number one choice as favorite snack is simply a Snickers candy bar. ...

Steve, yes, we do read in Alaska. However, we have both Borders and Barnes and Noble in the Anchorage area. The plus side is we actually have several...

I had been assigned a small project to manage with one tech person to do the work. (at the time, I was managing 8 projects ranging in staffing needs...

This is actually my second busiest time of year at work. So, no time off. And, unfortunately for my wife, who is a social worker, this is her...

I worked on a project once (merging lots of applications into an Enterprise Application) where one of the software companies contracted personnel who was working with us, gave us...

HUGE difference using two monitors. I have two workstations in my office. One with a 21" LCD, and the other with two 19" LCD monitors. The workstation...