I haven't got anywhere to test this at the moment, but I think you need to join Course_Module twice to Batch instead of once to Batch and once to itself.

John

Craig

Blocking shouldn't cause your reports to show the wrong (or no) data... unless there is a timeout on whatever application runs the reports. If that's the case, you might...

Try this:

...

execute (@suspendname)

...

John

What command are you using to create the database? If you're using the GUI, please use the Script button to generate the script that gets run behind the scenes...

This sounds like an interview or homework question. What research have you done?

If I'm wrong about that, what is the exact problem you're trying to solve?

John

That's not two primary keys. It's one primary key constraint over two columns - a composite key.

John

Is this an interview question, by any chance? What research have you done?

John

We can't see what you can see, so help us to help you. Please write a RESTORE statement for each operation. Post all the statements, along with any...

Go on to the Quest website and do a search. There's a utility that you can use to turn a LiteSpeed backup file into a set of native files....

OK, if your're running exactly the same code - and you may want to check it's exactly the same - then it's got to be environmental. Try putting SET...

Sorry, meant SSMS.

John

Mmmm... what happens if you paste that code into SSIS and run it there? I wonder whether it's anything to do with SET QUOTED_IDENTIFIER?

John

I don't understand. If that's how it is in your package, what was it you posted earlier?

You need the single quotes on all lines, even (especially) the ones with...

No. You need to wrap all non-numeric items in your INSERT...

You're muddling up your single and double quotes. Use single quotes (') when quoting something in T-SQL, and double quotes (") when quoting something in an SSIS expression.

John