Link to home
Start Free TrialLog in
Avatar of Rayne
RayneFlag for United States of America

asked on

TSQL Question

Hello

There is table that stores metric specific to the combination of account and product, period. The data is appended to the table  with time stamp (last column)
Now how do I do something in TSQL  - for each combination of account, product, period – get me the difference of metric1 of 5 jan to metric 1 of 1 jan. Please look excel

Thank you
eu-qestion.xlsx
SOLUTION
Avatar of PortletPaul
PortletPaul
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Rayne

ASKER

Portlet Paul,

You are my life saver, thank you again. You have jumped in to help several times before as well.

Thank you Sire :)
Avatar of Rayne

ASKER

this is awesome, thank you again. I was stuck in a mud slide :(
:) thank you, it's my pleasure. Cheers, Paul
Avatar of Rayne

ASKER

Thanks again Paul, this again helped after 1 year AGAIN :)
You rock
:) too kind. All the best, Paul