guy 10462 (4/26/2012)

---

Something in my brain just went 'what?'

We currently keep the last 6 days of backups, so are you saying that the older 5 backups are worthless? - or...

12B (4/26/2012)

---

Thanks for your reply. Can you help me with this. How to check my server having Sql is up to date with Sql patches or updates. Is there any...

Larry Page(Ehsan.Akbar) (4/26/2012)

---

maddencircledme (4/26/2012)

---

I want to be able to run a stored procedure to pass the MDX statement to SSAS but I'm not quite sure of the syntax. Do I...

Try this to start: http://sqlblogcasts.com/blogs/drjohn/archive/2008/09/27/mdx-and-sql-combining-relational-and-multi-dimensional-data-into-one-query-result-set.aspx

You can use either. Maybe posting the script would help 🙂 (Not maybe... It would.)

What are you executing? What is the exact error you are getting?

I don't quite understand... Are you trying to query the cube through a connection to the database engine or through a connection to SSAS; i.e. when you have the connection...

The _1 is typically default. Just curious... Why is it important for you to rename it?

You can do SELECT @@version and compare that to this.[/url]

Please take a look at the article in my signature by Jeff Moden to help us help you better.

Lynn Pettis (4/26/2012)

---

SQLKnowItAll (4/26/2012)

---

FunkyDexter (4/26/2012)

---

I apologise, Lynn, but my inner pedant insists on butting in here.

The first column of your table is an integer field defined with the Identity property....

FunkyDexter (4/26/2012)

---

I apologise, Lynn, but my inner pedant insists on butting in here.

The first column of your table is an integer field defined with the Identity property. You have to...

Try to find the real length of the data in the old table. You can so SELECT MAX(LEN(columnA)), MAX(LEN(columnb)), ... to find out what your new table needs to have...

For my own understanding... We are talking about select1 and select2 being in the same transaction. Am I wrong? I would assume different results otherwise in a highly active...

bpowers (4/25/2012)

---

Below is an example of a script I have, which works fine. However, I would now like to multiply the "AVERAGE_QTY" by the "USED". Any idea how I can...