sstilos

Hello, I was trying today to execute the use this one : ...., DateTime(Concat(Day(rt.DateTime),'-',Month(rt.DateTime),'-',Year(rt.DateTime))) as test .... , but I get as response the following message : "'DateTime' is not a recognized built-in function name.\r\nIncorrect syntax near the keyword 'AS'.", Do you know if the…

It works as expected. Thank you very much.

Hello, I try to join the table Orion.Nodes with the table Orion.CPULoad which has more than one occurences of a node and I want only the TOP 1 record for each one based on the timestamp field. As I can see it can be solved by using the CROSS APPLY command, which is not supported from SWQL. Can anyone,please, suggest me…