What's not ordering correctly?  The query or when you select from the temp table?

This should be very straight forward in powershell.

$testy = @("C:\Test\test.txt", "C:\Test\st.txt")
If( (Test-Path $testy) -notcontains $false)
{
 Move-Item $testy "C:\Test\Test\"
  Write-Output "All found"
}

You can also show the execution plans with and without the index.

No you shouldn't write code with just the goal of not failing test cases.  For your personal tests you should be testing it enough to verify that it meets the...

There's a few options, one and this might be easiest is just to wrap all your fields in " in the query or just stripping the commas out of the...

And what are the rules you are using to derive those numbers for a specific user for a specific ticket?

The first step, you pray that whoever built it used somewhat intuitive names for tables columns and constraints.