I just scheduled the rest of my time off for the year - every Friday until Christmas. 😀

Generally, in the beginning of the year, I'll schedule a week off for...

How about using IN?

SELECT CASE

WHEN RTRIM(Customer.Source) IN ('CREDITNEW','CREDITOLD','TOC') THEN 'CREDIT'

WHEN RTRIM(Customer.Source) IN ('DEBIT') THEN 'UC DEBIT'

WHEN RTRIM(Customer.Source) IN ('DEBITOLD','DEBITNEW','TLC') THEN 'DEBIT' -- Defined orginally with space, Crystal uses the...

Grant Fritchey (10/22/2013)

---

Only because instead of managing a single file now you're managing many. Sometimes it's the only way to get the job done, but it does add a wrinkle...

Grant Fritchey (10/21/2013)

---

I'm pretty sure you can use one of the file splitting utilities to break them apart and put them back together even though they're encrypted. Other than that,...

I have to agree with the Kindle love. I have a third generation Kindle (greyscale, no touch screen, no back light) and I absolutely love it. I do...

On a few of my instances, I've increased the Database Mail Executable Minimum Lifetime (seconds) from 500 to 43200. You can find that by risk-clicking on database mail -->...

jeff.stanlick (9/10/2013)

---

paul.knibbs (9/10/2013)

---

Frankly, it seems to me that having the company which is selling the software also providing the certifications for that software is a conflict of interest which is...

Lynn Pettis (8/31/2013)

---

The problem as I see it, especially at the high school level, is the girls don't want to be perceived as nerds or geeks. Trust me, I...

MyDoggieJessie (8/27/2013)

---

You can override the data source credentials on the report server. Go to the data sources and set the account you want to use, then in your BIDS...

RonKyle (8/22/2013)

---

The application may be performing poorly, but it's not a chokepoint in the sense that the database is....

Craig-315134 (8/21/2013)

---

@RonKyle wrote:

The database is a chokepoint ...

I can't imagine it being a chokepoint any more so than anything else. Network bandwidth can become a chokepoint. So can application servers....

Ralph Hightower (8/2/2013)

---

I'm anxious to see The Masters in person. My wife and I used to visit her father and step-mom on The Masters weekends and watch it with them.

The...

Ralph Hightower (8/2/2013)

---

I'll continue with photography as a outlet to C# programming. I am in a very small minority in the local camera club since I'm the only one that...

I'm currently pursuing an MBA. But the rough part of it is the summer class I'm taking right now. Hopefully I get a little more breathing room when...

pwalter83 (7/31/2013)

---

Sean Lange (7/29/2013)

---

Since you started a new thread and Chris pointed me back to this one I will post here.

I would agree that trying to keep this data in...