If you put the whole query into SSMS 2008 and run it without removing the 'GO' commands you will still get the same results as shown below.

Msg 2714, Level 16,...

Hugo Kornelis (2/11/2013)

---

When picking my answer, I knew I had a 50/50 chance, because my mindreading skills are still not on par with my SQL skills.

There were two options.

1. The...

Hi,

Did you manage to resolve this at all?

Or can anyone answer this?

Gary Stacey (2/6/2013)

---

I got it wrong!

I'd applied BODMAS to the 4 statements so I figured it was a different answer. Thought my reasoning was sound, so I checked the...

When your in a report project on the menu bar under 'Report' there is the 'Report Parameters' you can create them there!

Then do the calculation in the data set and...

I knew there was a trick to this one,

really good question thanks 🙂

Really depends on your resources, you could have a separate server for each aspect or 1 server for all.

I've always had at least 2 anywhere i've worked 1 for live...

Some mentioned that book to me previously but said it was too advanced for someone still learning.

What do you think?

Thanks Koen,

I was looking at the first one, the second one I'd not seen before.

Then i'm baffled,

I've rebuilt the entire Cube and tables from scratch and the data is spot on at that point, but then won't update the data on the next increment.

Regards

ld

Hi Sam,

Thanks for the reponse.

I don't have permisions to run SQL Profiler, this has been deemed a DBA function... :unsure:

Could it be to do with the server being Standard Edition?......

:-D:-P

Just found this looks like the 1048576 will be kept for 64bit versions aswell....

Excel 2013 is already introduced to us as part of ms office 2013 suite. Office 2013 is...

Hi,

I just remembered 1048576 is the maximum row limit of any excel spreadsheet from excel 2003 upwards.:w00t:

It's the memory limitation due to the package being 32bit, when they go to...

Ah fantastic 😀

Learnt something new there. :w00t:

In my environment you can set the maxium rows to 1048576.

Thanks

ld

.