Search results for query: *

Perfect! This works swimmingly well!!!!!

We are using SQL Server 2012, thanks, I will take a look at this

Ah yes, I see what you mean, and sorry for that. I guess I should say I'd like to have a null when the last 5 values do not match.

Hello, I am trying to check the last 5 values of a column for each employee and if they match then i want to show that value, if they don't match, i want to show the most recent value. thanks in advance! D

Thanks to you both for great solutions and speedy fast, thanks again!!! D

Hello there and thank you in advance. I am trying to populate a column (week_number) in my employee table. I need to insert a 1 at the first entry_date and then increment by 1 for every entry_date after, in sequence for EACH employee. The issue is, each employee can have a different entry_date...

Perfect! Thanks so much!!

i need to find out the difference between sequential week numbers and store the value on the current weeks row. How can i do this is a view. I have id, shipped and week number columns as shown here, I need to get the 'desired value' column to use as a denominator. Any ideas? Great thanks in...

Is there a way to transpose data in Excel as in the example below? the id column i would like to repeat down the rows and the corresponding rec_ids listed out instead of the comma separated values. data as it stands in Excel here is what I want in Excel thanks, D

I have two data sets in a report document. R1) Date attribute with a metric value of sysdate()-1 which shows up as 20120626 for today R2) Date attribute with a metric value of maxExecutionDate which shows up as 20120625 for today What i am trying to do is create some conditional format to...

Is is possible to create a report to show the top 5 customers in sales individually and the remaining customers grouped into 'Other' or 'everyone else'? Point me in the right direction Thanks, d

Take a look at the following thread in the MSTR Knowledge Base, I think it may give you the information you need. TN5200-7X0-0155 Hope this helps, dinzana

Thanks Skip, it worked like a charm! You're a Star! dinzana

Hello All, I am trying to format a cell to be a certain color and have a double line border at the top of the cell if the value of another cell is ='Total'. I have tried conditional formatting but there are only single line borders. Here is the code that is generated when I record a macro to...

Hello All, I am trying to format a cell to be a certain color and have a double line border at the top of the cell if the value of another cell is ='Total'. I have tried conditional formatting but there are only single line borders.. thanks so much in advance. dinzana

In Desktop it is possible to force data to export to a specific Excel file, which allows me to format a nice reporting workbook etc. Is it possible to do this from the Web Interface? Thanks in advance. -dinzana

Hello All, Has anyone run into an issue where a nested prompt that works properly in Desktop is NOT working when executed in MSTR Web? What the???????? Is this some sort of bug? I am using version 8.0.2 Thanks in advance, -dinzana

Hello All, Thanks in advance for your help. What is the following line of code trying to do? translate(substr(<columnName>, instr(<columnName>, , '|', 1, 1)+1, instr(<columnName>, , '|', 1, 1)+1), '_0123456789','_') Thanks again! -dinzana

GOT IT! Thanks to you Sunil and thanks to MonkSnake for all of your help! select accountID, startDate, isnull((select min(startDate) from @tTEST where startDate > T1.startDate and T1.endDate = endDate), endDate) as endDate, (SELECT SUM(amt) FROM @TEST T WHERE T.AccountID = T1.AccountID and...

Sunil, thanks so much, that is close, but the endDates in the resultset are all 04/02/2007. I need them to be the startDate of the next record. See what I mean? Thanks so much for looking at this. -dinzana