I get to Nashville several times a year. Can I share in a couple?

SQLRNNR (6/13/2011)

The Dixie Flatline (6/11/2011)

Obviously not... the Back Street Boys are a...

Jeff Moden (6/12/2011)

I like that quote. Here's another one that I frequently use on managers that promise...

I might actually enjoy working for people who knew what it meant. 😀

I suspect the TRY...CATCH doesn't work the way you expect because the TRY is actually succeeding.

Procedure dbo.sp_start_job runs twice, successfully sending start job requests over to SQLServerAgent...

It seems simple enough. Do four different insert queries.

1. Insert Into PaymentItems Select (some columns)

2. Insert Into PaymentItemD_zAgro Select (some columns) where Type = 'agro'

3....

If I passed, could I add "Thread Certified" to my resume` ?

Saif:

What we are hearing is that you want to audit the changes: logging the data before the update is committed along with the data after the update is committed. ...

You can use either. I typically use decimal.

With respect to performance. You will not see a significant difference, if any, between the two.

Money types provide display...

You are joining two subsets of the cookies table to each other. Assuming you want filter each set by those dates, you simply need to add...

Is there such a thing as an LVP?

I'm looking for an attainable goal for the 2nd half of the year.

Obviously not... the Back Street Boys are a totally different boy-band than...

APPLAUSE!

THUNDEROUS APPLAUSE !!

BRAVA !!!

Read up on the OUTPUT clause as someone previously suggested. It does exactly what you want to do.

It will enable you to store before/after data from every...

He said "sample" data. Feel free to make up fictional values to hide proprietary information so long as those values recreate the problem you are experiencing.

The reason...