Chris,

Thank you for the post.

Marc

Hello Lynn,

Yes, level1 item numbers are unique to level1 and so on

Regards

Marc

Thanks for your help Mark.

Here is the SQL I will be inserting in the Cube

Regards

select

a.recid,

a.PrinterID,

a.HistoryDate,

a.Totalcount,

Dailychange = a.totalcount - isnull(b.totalcount,0)

FROM

(SELECT row_number() OVER (ORDER BY p_printerID, pmh_pollDate ) AS...

Thanks for both of your suggestions. They work perfectly. Thanks for your help once again. This forum rocks

🙂

I guess I pressed the wrong key. The reply posted before is not complete

Here goes again. It's kindda typing please read attached in an email without actually including the attachement.

SELECT...

Hello again Jack,

Here is the statement you helped to create. Thanks

SELECT datediff(mi, DATEADD(Second, CONVERT(INT, SUBSTRING(datetime1, 13, 2)),

DATEADD(Minute, CONVERT(INT, SUBSTRING(datetime1, 11, 2)),

...

Thanks for your help. I do appreciate this forum

Regards

Marc