Stewart hit the error. I think you can see it better when you look at the code as I have it formatted:

SELECT

rh.Branch,

...

Proper forum etiquette would have you share your solution with others. It may help someone with a similar issue.

Which can be done one of two ways in SQL...

Andrew-495157 (9/10/2012)

---

Lynn wrote "You really don't get it, do you"

In the UK this would be considered a provocative and rude statement. I will assume cultural differences apply here.

Having used RBDMS...

Andrew-495157 (9/9/2012)

---

Lynn wrote "This means it HAS TO do an implicit conversion of the nvarchar value 'AB' to INT in order to complete the test and fails since 'AB' can...

And just so you know, you would have this same issue if the database was Oracle as it uses a similar data type precedence as SQL Server when doing implicit...

Andrew-495157 (9/9/2012)

---

SELECT Job_Bag

FROM Job_Bag

WHERE

Job_Bag.Description_Reference = 1609

AND Job_Bag.Cust_Order_No = '70255'

* A row exists which matches the WHERE cluase conditions

* The row with value 'AB' in column Description_Reference has value...

And actually, you didn't describe exactly the results of the query I asked you to run....

Lynn Pettis (9/8/2012)

---

Didn't ask for a description, I ask for the results of a specific query that would return 2 columns and an unknown number of rows (possibly 2).

Copy paste...

Yes, if you read the first post it says taht.

Did ask for a description, I ask for the results of a specific query that would return 2 columns and an unknown number of rows (possibly 2).

Copy paste normally works...

I asked for the results of the query, where is it?

Are you afraid to post the results?

Evil Kraig F (9/7/2012)

---

Lynn Pettis (9/7/2012)

---

Evil Kraig F (9/7/2012)

---

Now, if you pushed it for a mile or two and it took half an hour... I'd just say thank you, take...

Run the following and post the results:

SELECT

Job_Bag.Description_Reference,

Job_Bag.Cust_Order_No

FROM

Job_Bag

WHERE

Job_Bag.Description_Reference = 'August 2012' or

...

Andrew-495157 (9/7/2012)

---

As I mentioned before there was already the value "AB" in a row in the table which cannot be converted to a string.

So one might expect the code to...