Hi Nicole,

I may not have a complete solution for you, but here are my initial thoughts...

"Loop through all the tables (from a list)" -> You can use a...

smacq (5/20/2016)

---

Another newbie question. I already have SQL Server 2012 loaded. Used it to pass 70-461 two weeks ago. I already have the AdventureWorks DBs loaded. ...

You're welcome. Happy studying!

In addition to.

Go...

I just used this tutorial to set up my lab environment for the 70-462 Training Kit. It is very thorough and useful! Thank you for taking the time to create...

41,000 Blu-ray disks, billions of MB sized pictures...that's amazing. All this data makes the business intelligence & data analytics fields look very promising for the future. Someone needs to sift...

You are right about the <= comparison. I was using <= for the join condition, and just changed it to <.

JOIN cteTally t ON p.StartTime < DATEADD( dd, DATEDIFF( dd,...

Jeff, thanks for that warning. I will look into that.

Luis, I noticed that the HoursPerDay is a little off for the case "When last day of multiple days". It's not...

Ok, thank you for the update, Luis.

Luis, that seems like a great way to accomplish what nailers is trying to do. I would like to take some of your ideas for what I am trying to...

Possibly. I am looking at your tally table. Thank you for sharing.

Thanks for your quick response, Sean. I will try to make it more understandable.

Phil, thank you for your article. As a recent Management Information Systems student, we read case studies of IT mistakes and disasters in various organizations. It was helpful to learn...