Can you give...

SQLTougherGuy (6/17/2014)

---

Thanks very much. That really helps in my analysis. I always say that unless your really need the new "bells and whistles" of 2012, I don't see the point...

Kaput?

Oh Steve, why have thou forsaken us?

vignesh.ms (6/14/2014)

---

how to load all files in a directory in ssis with different delimiter ?

I have tried this using Foreach File Enumerator. It works fine for same delimiters, but I...

There are quite some differences between 2005 and 2012, in all three of them.

SSAS will be OK for most parts. SSRS might be more difficult, as 2012 uses the more...

If money is an...

Ryan1 (6/17/2014)

---

Attached is what my dimension usage tab looks like.

Gender, Automobile, and Customer is from view one which contains only data that is directly linked to dimensions.

Dates is a...

I beg to differ:

SELECT ID...

Inception!

EdVassie (6/17/2014)

---

The SQL Server install will fail if both the account running the install and domain name are the same.

Create a different account on your machine and rerun the install...

Maybe your production database got slower 😉

Since transaction are atomic, you cannot resume them somewhere in the middle. Either it finished, or it rolled back and "never happened".

No problem, it is my pleasure. 🙂

Do it like this:

WITH CTE_Test (ID)

AS

(

SELECT CAST(id AS VARCHAR(60)) FROM cat_transaction

EXCEPT

SELECT ext_reference FROM Patricia.dbo.BUDGET_LINE

)

SELECT @Total = COUNT(ID)

FROM

CTE_Test;

If someone at the company has an MSDN subscription, you can download the SQL Server installation media.