Thanks 😀

Thanks 😀

thanks, does the master key have to be the same on the other server?. Didn't see the link :-).

awesome got an example of this 2 work 😀

ok 🙂

if I need the back up from the database to work on another server, do I just need the certificate and private key that the certificate was backed up...

Thanks 🙂

will do 😀

old data is archeived every night to make sure this row count doesn't go much higher than that 🙂

ok, thank you. The lots of data we have 🙂 there's over 5 mil rows, just need to make sure we use diff parameters each time

The code in the stored procedure is

SELECT ISNULL(Vessels.Name, 'unknown') AS Name, AISPositionsCurrent.MMSI, AISPositionsCurrent.Position, ISNULL(VesselGroups.Description, 'Unknown')

...

thanks guys 😀

I understand that no filter will be applied what I'm trying to find out is if the first part of and is true would the second part still run?

I have...

thank you 🙂

reading through that link now 🙂

will that give me the exact row or just the latest DateStamp? sorry I'm not the best at explaining things. Would the below work well?

SELECT GroupID,Name, Position

FROM MyTable

WHERE...

by latest row I mean that it will look at the DateStamp and get only the row with the newest DateStamp for each group