This challenge is related to an inventory management application where your job is to calculate the profitability by item (cost v/s sales) using First-In-First-Out (FIFO) processing method.
2010-09-20
2,137 reads
Learn SSIS from MVP Andy Leonard in Waltham, MA on Oct 6-8, 2010. This is a paid event. More details inside.
2010-09-16 (first published: 2010-08-19)
10,185 reads
A free one day training event in the Denver Tech Center on Sept 25, 2010. Come learn about SQL Server and how to further your career at this one day event.
2010-09-16 (first published: 2010-09-01)
1,549 reads
A free, one day training event taking place on October 16, 2010 in Orlando, FL.
2010-09-15
1,426 reads
The first SQL Saturday in San Diego kicks off fall with a full day of free SQL Server information, lectures, and seminars from the experts on the West Coast.
2010-09-14 (first published: 2010-09-07)
1,663 reads
Andrew Calvett talks Analysis Services for the September meeting of the Kent SQL Server user's group.
2010-09-14
1,427 reads
There's going to be over 30 hours of free online SQL Server training in the upcoming week and you're not going to want to miss out!
2010-09-13
1,806 reads
A free one day training event in Raleigh, NC. Come to the first SQL Saturday in this city on Sept 18, 2010
2010-09-13 (first published: 2010-09-02)
1,529 reads
SQL Saturday Columbia, SC gives you a chance to get a full day of free SQL Server information, lectures, and seminars from the experts on the East Coast.
2010-09-10
1,014 reads
Find out in this webinar how easy it is with Red Gate's SQL Virtual Restore to mount live, fully functional databases direct from backups – without performing a physical restore. Learn how you can use SQL Virtual Restore to save storage space and time across a wide range of database administration activities.
2010-09-09
1,093 reads
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Comments posted to this topic are about the item Restoring On Top II
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Comments posted to this topic are about the item Breaking Down Your Work
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers