I like to do this with update queuries to make sure there are no unexpected surprises occuring in other queues behind the scenes. You should be extremely careful if using this on a queue other than 1 for the same reason. MAKE SURE you change the queue id before running.

2. I also hard coded the priority in

set HD_TICKET.HD_PRIORITY_ID = 10

Make sure the id in the update query matches the one you got in the link above.

I always recommend having a test queue for testing update queries and hard coding the queue number to avoid mistakes that can cost data, time, and money, maybe even your job.