The Dixie Flatline (7/16/2014)

---

Woohoo!! Done with work for the evening, and in the morning we're heading to New Orleans for a long weekend. 😀 😀 😀 ...

Lynn Pettis (7/10/2014)

---

Okay. Curious if the OP on anther thread is ever going to say anything. Asks for help and doesn't quite provide enough to help. Posts...

More concerned about the...

Next time it hangs, before restarting anything, can you run each select statement separately and as 1 to see they all run?

And maybe without NO LOCK check also to see...

Could also be written as a CTE.

Moving Gold and Silver to the partners table, or other changes to more normalize (keys instead of descriptions) will change things.

select

[partner_id]

,[competency_name]

,[program]

,[SKUgroup]

,[competencyname]

,[start_date]

,[end_date]

from [dbo].[partners] a

inner join...

Gangadhara MS (6/26/2014)

---

Gold and Silver - is this related to Partner? Or to the Service being provided?

Its related to partner which they own it after meeting some sales criteria.

So...

So P1 overlaps in Small / MidMarket Cloud Solutions?

Gold and Silver - is this related to Partner? Or to the Service being provided?

insert into partners ( 'P1','5/10/2013','2/6/2014','Gold Small and MidMarket...

peter.cox (6/26/2014)

---

nope - the Cube is on another box

As to the whole Julian malarky - it's a pain, but entire system is set up like that. The fact the SP...

Just out of curiosity -

Have you ever tested with a Date / Year / Month / Julian table? And maybe one with current date populated daily?

We used this, and found...

I am doing a bunch of things.

Now I want to do another thing, and it is similar, just in SSIS.

Please tell...

Expected result is still not real clear.

It sounds like are looking for the Max for each competency.

I tend to agree with Grant's scenario, although you might also consider a slowly...

Run this on AdventureWorks cube.

Example of Product hierarchy.

I think it is what you are describing.

Basically show all members and showing no measure.

SELECT { } ON COLUMNS, { ([Product].[Product Model...

rodjkidd (6/19/2014)

---

And Greg, it's been getting worse over time already... It was only just about stable when I started. Just been overtaken by more important projects and priories... You know...

Sounds like it will only have potential to get worse over time, until the time comes when the business says 'enough'.

Fortunately I have had the pleasure of working where 'lights...

Ed Wagner (6/19/2014)

---

rodjkidd (6/19/2014)

---

So for my current gig, I'm not a production DBA.

We have a very temperamental server which is being upgraded this week.

It also has spaghetti jobs / packages....