Is your variable evaluated as an expression? If so, have you tried typing the "¬" characters directly into the expression editor? Another thing you could investigate is whether...

You do indeed have some strange hidded "¬" characters in that first part of the query. I managed to eliminate them by deleting that part and typing it in...

Thanks. Please also post the actual query and the actual error message.

John

Please will you provide table DDL for tabel1, a few rows of sample data and the actual error message you get.

Thanks

John

Is this homework? What have you tried so far?

Here's a hint: use GROUP BY and COUNT(*) in a CTE or subquery to find out how many of each product...

If you start SQL Server in single user mode, then assuming your machine\administrator account is a member of the local Administrators group in Windows, you will have full access to...

I'm happy to help to solve the problem, but I'm not going to solve it for you. The best way for you to learn is to try it out...

I think you just need to join the table to itself on t1.Customer = t2.Customer and t1.InvoiceNo = t2.InvoiceNo + 1.

John

Do you have any other account with full access to SQL Server (sa, for example)? Log in as that and recreate your account. Now log in with your...

What does the package do? Sounds like it may have altered some permissions.

John

You need to use a GROUP BY clause.

John

You need to run the two statements as one batch, since a variable will only "live" until the end of the batch.

John

Is this homework? Please show us what you've tried so far, and we'll see if we can help with where you're going wrong?

John

I don't know the answer to your question, but I can tell you what I'd do. I'd restore a copy of the corrupted database on to a test server,...

http://www.sqlservercentral.com/articles/T-SQL/62867/

John