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

Well, the clustered index is the data, so I think you're looking at the larger number. Index_size only includes, I believe, the non-clustered indexes (as well as XML, spatial...

Don't know. Where did that data come from?

John

In that case, I'm not sure why your transaction log should grow to nearly three times the total size of your indexes. Does that 60GB include the clustered indexes?...

Jason

You're only running one ALTER INDEX statement at a time, so it doesn't make any difference whether you use an explicit transaction or not. I think what Lynn was...