You're doing two different things in the two queries.

try creating it as a WITH SET instead of WITH MEMBER

Why dont you just set the flat file destination to output the header row?

TSQL Tryer (1/25/2016)

---

Hi Need to export a Date in this format - I've tried a number of things and can't get it into the specific format I require - please...

No worries 🙂

Ok lets take a step back if I may? what are you trying to achieve with the chart?

If I was to take a guess, you're trying to...

hmm ok, can you screenshot what you have in design mode please?

when you say grouping, have you created a new series or category group?

Try this, should do the trick.

Excuse the sloppy formatting 🙂

declare @AsAtDate Datetime = '2015-01-01'

;with

MinPat as

(

select patientID, indexenddate, M.MinDiff

,ROW_NUMBER() over (partition by patientID order by M.MinDiff) as RowNum

from [dbo].[MDTest2]

cross...

Indeed, just read what I initially wrote again. Shouldn't be allowed to use my brain before my first coffee 🙂

GilaMonster (12/8/2015)

---

No they don't.

Escalation is straight to table, no matter whether the locks start as row or page....

No worries, please could you mark the answer 🙂

Hi, are you asking how to model this, how to set it up in SSAS or how to write MDX to achieve this? 🙂

so you need to add parameters in the parameters folder under the "Report Data" pane.

If you want a list of values to drive these you'll need a data set for...

did you migrate logins between the servers before you moved the databases? its possible that some or all of the users at the database level have become orphaned from their...

locks escalate in three steps, row, page and then table. Its possible that you're not able to escalate to page for one of a number of reasons and therefore its...

what you're looking for is a row group within the tablix