Gary Varga (2/28/2013)

---

I've suffered a serious burnout once and a close call one other time. As with many things, recovering from going too far is harder than not going too...

Many years ago I was working to support a SQL Server based accounting system and had a very troubling issue that was ultimately found to have been caused by case...

Dave62 (2/22/2013)

---

I hear you. It seems like...

I was working in the accounting department of a small steel broker and they decided to implement Solomon Accounting software. They put the product on three standalone IBM XT's...

wolfkillj (2/20/2013)

---

batgirl (2/20/2013)

---

I'm having a senior blonde moment here...

What is the difference between:

THROW returns the same error message as the select statement

and

THROW returns the error message "why oh why do...

I'm having a senior blonde moment here...

What is the difference between:

THROW returns the same error message as the select statement

and

THROW returns the error message "why oh why do you do...

jcrawf02 (11/3/2008)

---

Politician AND a manure spreader - http://www.tomlynch4supervisor.com-a.googlepages.com/pastisprologue

By the way, what's the second half of the title?

"Life is like a manure spreader" . . .

. . . If you're...

To get last day of last quarter:

select DATEADD(qq,DATEDIFF(qq,-1,(DATEADD(qq,DATEDIFF(qq,0,GETDATE()),0))-1),-1)

Then add 110.

wireless

I agree that the wording was not the best, but I was able to figure out the intent.

I am stuck on the update itself:

-- #4 Final update with case statement

UPDATE...

I make sure to look for at least a touch of "customer service" skill no matter what the technical requirements may be.

It's also very important that someone be...

I may be missing something here, but why not just

update mydatabase

set stage = 'Awarded' where stage = 'Closed Won'

TravisDBA (2/8/2013)

---

You know, now that you bring that...

I had the extreme pleasure of working for Microsoft Business Solutions for a few short years and to date it has been my favorite workplace evah! We worked hard...

Yes, I wanted to complain about the True/False vs. Yes/No...but in all honesty I was easily able to correlate True = Yes and False = No. My problem was...