If you're working on Access, the syntax might be slightly wrong. However, the logic is there so you can correct it.

If you're working on SQL Server, you should change your...

sknox (11/24/2015)

---

Hugo Kornelis (11/24/2015)

---

The correct answer is missing: "The table doesn't have a primary key". It's also suspect that all columns are nullable.

From the answer options I deduced that I...

ningaraju.ne 46825 (11/24/2015)

---

Thanks Buddy,

But still issue exists as it fails when we compare normal strings.

DECLARE @C NVARCHAR(10),@R NVARCHAR(10)

SELECT @C=N'Ant'

SELECT @r=N'ant'

IF @r = @C COLLATE Latin1_General_Bin

SELECT 1

ELSE

SELECT...

In general, the advise is to avoid naming stored...

Maybe "What's wrong with this table?" should be change to something like "What's wrong with the syntax of this statement to create a table"?

The problem in here is the query. Other than adding hardware, there's no other viable solution.

If they're labeling the file name with an underscore, it's fine, but they don't need...

You could use RANK instead of ROW_NUMBER. That might lead to a different problem when you have duplicate rows in patientref.

If you have an additional column that deduplicates the row,...

Brandie Tarvin (11/23/2015)

---

It's not just you. Though, to be fair, Try...Catch...

Is it me or many people don't really understand error handling or why and how to use try...catch...?

If it gets into the CATCH, and the CATCH doesn't have a RAISERROR. Then, the agent won't consider the error.

Either you use RAISERROR or you use THROW. Otherwise, when you...

Brandie Tarvin (11/23/2015)

---

Luis, you are a better person than I am. I have no desire to keep encouraging the OP to ask for the query, so I am not answering...

My guess is that you can't have the proper indexes for the query to run correctly. The query needs to sort the patientref each time, which is what might be...

From what I understood from your problem, it seems that you were really close to the solution. You need to use the APPLY approach because you need to correlate your...

Does it really throws an error? Or does it just displays a message as configured in the TRY...CATCH...?

Are you using THROW?

I'm sure this is just a typical PEBKAC. 😀