Thank you Jeffrey , like your last comment, looks like you used  dense_rank() instead of rank(). this made the difference.

"RANK and DENSE_RANK will assign the grades the same rank depending...

it still displays '1' all over the column. I must be doing something wrong.

SELECT [day], [hour],
RANK() OVER(PARTITION BY [day],[hour] ORDER BY [hour] asc) Rank
FROM [dbo].['Detalhe OTM$']
ORDER BY...

Thank you. It works 100%

i do have. it is pretty much the same as this post from this user that i found later. trying to follow from here. https://dba.stackexchange.com/questions/223783/create-slowly-changing-dimension-table-from-repeated-data

• This reply was modified 2 years, 7 months ago by  rafamaniac.

every day a table gets updated from a linked server we have in our sql server (a server from a telecommunication company that gives us details about sales, login time,...

• This reply was modified 2 years, 11 months ago by  rafamaniac.

ok thank you, will see what the service broker can do.

Thank you. I have done what you said when importing dataset though SSRS and it's much simpler then to do anything code related in SSRS expression.

that is it thank you a lot. Best Regards

thank you, the trick was to make delay validations to true on data and foreach loop and also make a dynamic connection string with a variable filename something like "

Provider=Microsoft.ACE.OLEDB.12.0;Data...

i just cannot figure how to do this. so imagine i import file_x1, then after i imported it i delete it with a file task, but the next hour the...