kalikoi (9/19/2013)

---

gentleman thx for the code but here is my approach

composed a udf that returns the csv

DECLARE @StartTime TIME(0) = '00:10'

DECLARE @EndTime TIME(0) = '01:40'

DECLARE @MinutesToAdd INT = 5

DECLARE @RunningTime...

Very similar to the question a few days ago, but a bit harder.

Really nice question, thanks.

Stefan Krzywicki (9/18/2013)

---

Am I wrong in saying we shouldn't be using

SELECT * INTO #A1 FROM Table

SELECT * INTO #B1 FROM #A1

in production code? #A1 & #B1 are also never defined...

tester123 34641 (9/18/2013)

---

Hello

is there a prerequisite exam for 70-461 that must be taken first ? I work in the field already and use SQL extensively I feel that I can...

In Report Manager, right click on the report and choose Manage.

Go to data source and verify if credentials are entered.

clark.adamj89 (9/18/2013)

---

Thanks, decided im going to go with the pluralsight training, then when I feel confident I'll look to take some exams on my own accord.

Think that's going to be...

Personally I like printed books the most. Nothing beats the actual touch and feel of an actual book. (and you can kill flies with it!)

It's also easier on the eyes...

In SSAS Tabular yes, because that's an entire in-memory solution.

I'm not sure you can get the entire SSAS cube into cache with SSAS multidimensional:

http://richardlees.blogspot.be/2011/12/why-doesnt-ssas-cache-entire-cube.html

The Visual Studio reporting solution belongs to Visual Studio, the development environment. It is not deployed to the server.

You can however download the .rdl file, and add it to a...

If the user almost always wants data at the transaction level, why build a cube in the first place? Cubes are designed to give fast aggregation results, but they are...

http://stackoverflow.com/questions/1518823/how-to-find-the-port-for-ms-sql-server-2008

Please do not crosspost.

It wastes peoples time and fragments replies.

Original thread can be found here:

http://www.sqlservercentral.com/Forums/Topic1495763-3411-1.aspx

Please do not crosspost.

It wastes peoples time and fragments replies.

Original thread can be found here:

http://www.sqlservercentral.com/Forums/Topic1495763-3411-1.aspx

Please do not crosspost.

It wastes peoples time and fragments replies.

Original thread can be found here:

http://www.sqlservercentral.com/Forums/Topic1495763-3411-1.aspx

naresh.d14 (9/17/2013)

---

Hi Everyone,

I am having a problem while using Lookup...