My standard for documentation, in the code (comments) or in the project (ticketing system discussion thread), is that you have to document WHY some piece of code is the way...

michael vessey (5/23/2012)

---

Steve Jones - SSC Editor (5/23/2012)

---

Wouldn't that be?

Mr or Mrs or Miss or Ms 500

Too long, and to be honest, didn't think about it. Plus, could you get...

SQLKnowItAll (5/23/2012)

---

I haven't looked into it, but can't you include a data modeler and report builder with SSRS? So there are some reports that are standard, some that you...

Weird double-post removed.

I'm not clear on what you're trying to do with this:

case

when CAST(Data1 AS Int) < 0

then -1

else Sum(CAST(Data1 AS Int))

Are you trying to turn all...

I've got different solutions for different users.

I have a co-worker in one department who's competent enough with T-SQL queries to give her read-only access to the tables she needs to...

Log shipping is pretty easy to set up, in my experience. My first DR plan, when I had been a DBA for about 2 months, was log shipping, because...

Can you ask the customer about their rules on that? If not, you're crippled and will be working on "best guess" at best.

If it's mixed alphanumeric, you'll want to...

Oliiii (5/23/2012)

---

Lynn Pettis (5/10/2012)

---

Guess I'd fail here. First things I look...

You're using the sa login. Have you confirmed that the login still has full sys admin rights?

You don't currently have to terminate statements with a semicolon. However, you will have to at an as-yet-undetermined future date.

I don't know a tool that will automate adding them...

I can't test this, because I don't have your tables, but it should look something like:

case when SUM(CASE WHEN [departmentnumber] IN(091111,011111,181101,131111) THEN Chargeamount ELSE '' END) > 0 THEN 1...

Have you looked at Pivot and Unpivot on MSDN? It's in the From clause documentation: http://msdn.microsoft.com/en-us/library/ms177634.aspx

It looks to me like those will do what you need.

Here's what I'd do in this instance:

Set up an audit trigger on table 1 to track all inserts, updates, into it. Insert the data from the trigger into Table...

It will keep your most recent option...