Yes, you can use a WHILE loop, but I would not recommend it. According to the execution plan the WHILE loop is 24 times as expensive as the Tally...

Mh (9/3/2009)

---

So far, I have the following script written:

with set [Hrsused] as

'filter({[Dim Time].[Hour].Children},[measures].[Appt count] > 0)'

member

[dim time].[hour].[Hrsworked]

as 'count({[Hrsused]})'

please let me know how I can get the above result using...

Because it's the standard and it increases code portability. On top of that, it's easy...

Dave Ballantyne (9/3/2009)

---

Note that this will return potentially false positives for end of range..

Also it will not detect if the initial receipts are missing.

Do you know the expected ranges to...

The key that you are using for your month dimension represents both the month and the year even though the name column you are using shows only the month. ...

It helps if you have a tally (or numbers) table, but it's easy enough to generate one on the fly. I've used the sys.columns table here, which should be...

Here is what I believe is happening. Your FROM statement is doing an implicit join on the two tables. It is then calculating the original value for each...

peterzeke (9/2/2009)

---

To Drew Allen: if you look carefully at the data, you'll see that the datediff ("DAYS") between FROM_DATE (March 4, 2005) and TO_DATE (June 6, 2005) for row #4...

Just to clarify. Shouldn't 4, 5, and 6 be in the same group, because the length of time between 4 and 5 is less than 60 and the length...

Try this approach.

WITH UpdateRank AS (

SELECT RecordTS, ObjectID, Value, Row_Number() OVER ( PARTITION BY ObjectID ORDER BY RecordTS Desc) AS RowNum

FROM #mysourcetable

)

UPDATE...

You DO NOT want to do a CROSS JOIN here. The problem with your original query is that a LEFT outer join will return all records from the LEFT...

The Conditional Split Task can only access information in the Data Flow, so you need to do your lookup before you get to the conditional split. You'll also need...

Without access to your cube, it's really hard to come up with the exact syntax, but you're going to need something like the following

Generate(

( x.CurrentMember, y.CurrentMember...

You haven't really given enough information for us to help you. Do you want the max date for the entire cube, for "Y Name", or for the "My Name,...

Nope. SQL evaluates the WHERE clause before it evaluates the SELECT...