Sean,

Here's the relevant code:

ALTER TRIGGER [dbo].[tI_timCustItem] ON [dbo].[timCustItem] FOR INSERT AS

/* Copyright (c) 1995-2011 Sage Software, Inc. All rights reserved. */

BEGIN

DECLARE @numrows INT,

@nullcnt INT,

@validcnt INT,

@errno...

Jeff,

Thanks for the article. I was considering going down the function path when I thought there was a better way. Glad I looked. In my case I...

Stole your code, thanks!

I'm glad most of you enjoyed the question. Steve actually called me and wanted me to do some benchmarking between the answers. After a very heated discussion we...

None planned now or in the near future either. Recently there was an article (on InfoWorld) about a mid sized Cloud Hosting company that went bankrupt. They gave...

Jeff's "rant" sure hits home. I think it's only going to get better when the data owners are going to be held accountable whether it's through insurance, criminal proceedings...

I think PowerShell is very cool but I've only ever had a use for it once. I use it to clean up my backup directories. There is just...

Did you have any luck on this? It looks like the best I can do is return one row from the left table and between 0 and many possible...

WOW, I wonder how often that was said when African Americans applied for jobs in the south at an all white company??? WOW.

One of the cooler projects I got to work on was a PayPal competitor from 2 large competitors. The project ended up failing because PayPal was already BIG but...

Second David Poole's comments. I am looking at building small apps for researchers and AWS is probably how I'm going to go. Even using free SQL Express wasn't...

I think you misunderstood. Steve thinks you should work a few hours at home (after work) doing a small project over a week or two and get paid for...

I think that's sarcasm (I hope).

In "our" industry we have code/process that do everything from keeping track of the number of labels purchased and used (not even close to life and death) to running a...

I went to the one in Redmond a couple of weeks back. I enjoyed it, especially learning more about HDInsight. As an old time programmer (TRS-80 with a...