Here's my story:

How I prepared myself for the MCSE certification

Luis Cazares (7/24/2013)

---

I believe this option is better for performance.

SELECT ID,

SUM( CASE WHEN Type = 'a' THEN Amount ELSE 0 END) AS Amount_A,

...

Just a small remark: Henrico's SP is great, but you cannot use it in the Excel Source with an Excel connection manager. You need to launch the sp from an...

Identity is not the data type, INT is.

The identity property specifies that this column is autopopulated by an integer, starting at 1 and adding 1 for each new row.

Great question. Never use full text search though, so definately learned something.

Great question, thanks.

Welcome to the forum!

Something like this maybe?

WITH CTE_ID AS -- get list of IDs

(SELECT DISTINCT ID FROM MyTable)

SELECT

ID

FROM CTE_ID

LEFT OUTER JOIN

(SELECT ID, SUM(Amount) FROM MyTable WHERE Type = 'a' GROUP...

If you use the service account directly (so without a proxy), there are still some very minor differences in permissions. I've read about it a long time ago and don't...

Typically, and this counts for a lot of sources, you do some sort of data gathering and put everything in one place (in BI terms this is called ETL and...

L' Eomot Inversé (7/23/2013)

---

Something over 28 hours since message notification from SQLServer Central last arrived here. This drying up of notifications seems to be happening rather often recently, is...

jcrawf02 (7/24/2013)

---

Koen Verbeeck (7/23/2013)

---

Probably, if I wasn't already 😀

(in my...

Sean Lange (7/23/2013)

---

Koen Verbeeck (7/23/2013)

---

I will save a spot for you. It can't be all that bad, I mean so many of my friends will...

Ya rly

(I now officially go to hell)

Probably, if I wasn't already 😀

(in my defense, it was...

Didn't know this site censored some words.

Hum. Whaddayaknow...