mbraman (4/28/2016)

---

The data I presented is pretty much it.

I want to be able to query for a total for the year 2016 without it adding up all 4 rows. ...

mbraman (4/28/2016)

---

I will first of all draw out my issue:

EmpID Date FieldName FieldValue Total

1234 ...

At least you didn't get this.

Sounds like you've fallen foul of the new Cardinality Estimator.

Please have a read here [/url]& you'll get a better understanding of what it is and how to handle it.

RickNPHX (4/27/2016)

---

Hi,

I saw the following statements in a SQL DBA 2008 R2 and 2012 class text, and wondered why you cannot install all components in more that one instance? Does...

As a general rule, it's better to put IsNulls inside Sums rather than outside. This avoids the warning message about NULL values being eliminated:

Select Sum(IsNull([Col],0))

No problem. Thanks for posting back.

I was just about to question your 'steroids' comment, Eirikur, when I noticed it had been edited out!

vprunic (4/26/2016)

---

Hello all,

Im not an expert so, still struggling with some issues, and was hoping I could get some help

How would I be able to rename all the members that...

Storing passwords anywhere in plain text, when there is an alternative not to, is why.

As simple as this, or more sophistication required?

IF OBJECT_ID('tempdb..#test', 'U') IS NOT NULL

DROP TABLE #test;

CREATE TABLE #test (Id INT, Value VARCHAR(20));

INSERT #test

...

What is the scope of User::SheetName?

So _xlnm#_FilterDatabase is the name of the first tab?

What is your connection string expression?

DuncEduardo (4/25/2016)

---

Hi,

Having a problem getting a package to work.

This package is supposed to load multiple sheets, from a single Excel workbook, into SQL Server 2014.

I am using Visual Studio 2012...

DuncEduardo (4/25/2016)

---

Phil, it turns out that if I run Visual Studio Pro 2012 on server "as admin" then I'm able to save and execute package (fixed minor errors).

In addition I...