Good question 🙂

Problem Resolved.

It seems that this error is caused by there being a difference in the ‘Time out’ between datasets, whilst the main dataset was set to 500 seconds the dataset...

Hi,

I'm using SQL 2012

It takes under 20 seconds in SSMS

Timeout is 500 seconds

I thought as much, any ideas how to construct the query? it seems to be failing because no data is returned from the execute.

[Quote]

--Using SQL Server 2008R2 or 2012

[/Quote]

#Sarcasm 😛

took a stab in the dark... missed totally

good question, look forward to playing with it when i finally get 2012 :-P;-)

Back to basics, but got me looking for a bit of trickery! :-P:-D

+1

L' Eomot Inversé (2/21/2013)

---

Good question.

I'm glad that missing out WITH is deprecated though, so that teh answer to this question will change in the future. In fact I think...

I see what you did there, nice 1.

Good Question!

oh if only we had 2012 :'( lol 😛

got 2 out of 3 right guesing after googling how THROW works :w00t:

good question and well written 😛

Brilliant Stairways series,

1 Note to make in the example code, when instructed to copy & paste out on each section of code where you have written [Calendar Year] on...

Not confessing to be the best a writing English, personally I use far to many abbreviated/ slang and shortened words (probably due to my age and/or regional location) but this...

Thanks for keeping this going, putting it all to good practice 🙂

1 Thing to note:

We will cotinue the series by looking at some important MDX features and topics necessary for...

I saw that the the CREATE TABLE and INSERT INTO #Table would conflict therfore running it as one batch (as stated in the Question) would error the whole statement regardless...