spaghettidba (10/27/2014)

---

It doesn't look like you're logged in as a domain user:

Either log in as a domain user or run Management...

That's a bit of a vague question.

Do you need to merge them permenantly, or do you still need SP1 and SP2 seperately?

Or do you just need this one resultset for...

mohammedaala (10/26/2014)

---

Hello Team,

I have installed Sql Server 2008 R2 in my local machine and when I tried to open SSIS solution on my local machine I am getting below error:

"Microsoft...

karthik babu (10/27/2014)

---

Hi Steve,

I got the below answers in my SQL 2014 instance.. Could you please explain why this answer was incorrect...

Escobar2014-04-06 00:00:00

Escobar2014-04-07 00:00:00

Escobar2014-04-07 00:00:00

Jeter2014-04-01 00:00:00

Jeter2014-04-01 00:00:00

Jeter2014-04-01 00:00:00

Tulo2014-04-01 00:00:00

Tulo2014-04-01 00:00:00

Tulo2014-04-01...

Great question, thanks.

That's what we call a "typo".

cafescott (10/24/2014)

---

I've said this before, so hopefully I don't come off as a broken record. However, I would never use derived columns in SSIS. Instead, I would use...

shield_21 (10/24/2014)

---

Thanks Koen for providing insights.

I had worked with SSRS. Little experience with SSIS. No experience with SSAS. My experience is on building databases and reports of web applications.

I'm...

Which one? The CountDistinct or the Aggregate one?

For the people who stumble upon this thread that might be good to...

I guess SSRS uses SUM or COUNT in the tablix?

Change this to AGGREGATE. This pushes the logic of aggregating to the cube.

kd11 (10/23/2014)

---

I'm trying to import an Excel (.xlsx, MS office 2010) spreadsheet in to my SQL (2K5) database. When I used the Openrowset('Microsoft.ACE.OLEDB.12.0......) I receive " The OLE DB provider...

Nope, only 3 and that's apparently already enough to make a...

If the data doesn't need to be in seperate columns, you can just concatenate the row values (and this works better if there is no fixed number of values):

Concatenating Row...

spaghettidba (10/23/2014)

---

Jack Corbett (10/23/2014)

---

spaghettidba (10/22/2014)

---

Stefan Krzywicki (10/22/2014)

---

Of course, regionalisms mean it could be called most anything.

For example: In most of the USA, a blended milk and ice cream...

According to the following thread you don't.

http://dbaspot.com/ms-sqlserver/475759-license-needed-install-ms-management-studio-client-tools.html

If you have a license per connection, that you need to make sure that is covered of course.

In case of doubt, it's always better...