Somebody is about to submit an astounding piece of homework http://www.sqlservercentral.com/Forums/FindPost1244144.aspx

Loundy (1/31/2012)

---

I believe something like this will do the trick.

Alternatively you could use the sql MERGE statement to MERGE table1 into table2, then MERGE table2 into table3 then MERGE table3...

Specifically you need to look at INNER JOIN, and the ID column is what you would use in the 'ON' part of that command.

Seriously, read up on this area (you...

You need to read about JOIN - http://msdn.microsoft.com/en-us/library/ms191517.aspx and look at the column that each table has in common.

I'm about to register for PASS 2012 (I have to register now as I'm paying for myself and it doesn't get cheaper as it gets nearer) and I was wondering...

Count the number of '(' and ')' that you have in those statements. You have 6 '(' but only 5 ')'. It is complaining about the '100,' so try '100),'...

You might have a misunderstanding of what the Log file contains. From the way you asked your question I think you believe the Log backup contains the state of the...

Very similair to Gail's description, but with pictures:

http://sqlskills.com/BLOGS/PAUL/post/TechEd-Demo-Creating-detaching-re-attaching-and-fixing-a-suspect-database.aspx

The Night Before Startup

'Twas the night before startup

and all through the house

not a program was working,

there clicked not a mouse

The users were nestled all snug...

A good start for these questions is the 'Stairways' series on Transaction Log Management:

http://www.sqlservercentral.com/stairway/73776/

You two are far more devious than I - but now I'm wondering...

If I recall correctly, one of the finalists wants to be in space because, as a six-year old he said such a thing and was laughed at by his teacher....

Search for 'Business Days' on this site - it produces a large list of articles tackling this problem in a variety of ways.

Fascinating question Hugo, thank you.

I had to re-read 'Formatting Your FROM Clause' in the first volume of 'MVP Deep Dives' to answer it. Knowing where to find the answers is...

That's quite a request you've made there...