SQL SERVER – How do I Record Video and Webcast – Milestone – 2200th Blog Post – SQL in Sixty Seconds #022 – Video

Earlier I used to do Milestone blog posts where at the interval I used to celebrate achievements. However, as time passed the achievements changes their value and importance. We all grow more and more and our priorities are different. However, today I have come across a very interesting milestone! This is my 2200th blog post as well today is our 22nd Episode of SQL in Sixty Seconds Series.

SQL in Sixty Seconds series was started with the a very simple concept. Learn something in a very short period of the time. Our life is very busy, we move pretty fast now a days. We do not have enough time to sometime to learn something new. In this SQL in Sixty Seconds the goal is to learn something on the go! Well, it seems that it has worked a quite well because as our SQL in Sixty Seconds Channel is very popular and most of the video have 1000+ views. I thank Vinod Kumar and Rick Morelan for their contribution in this Sixty Seconds Video.

One of the most popular questions which I receive is how do I do this video and what kind of equipment I use for the same. In today’s SQL in Sixty Seconds we are going to see the same. This video is by my Nupur Dave, she recorded it while I was actually recording SQL in Sixty Seconds.

Watch Last 5 Episodes of SQL in Sixty Seconds:

I encourage you to submit your ideas for SQL in Sixty Seconds. We will try to accommodate as many as we can.

If we like your idea we promise to share with you educational material.

Reference: Pinal Dave (http://blog.sqlauthority.com)

About these ads

8 thoughts on “SQL SERVER – How do I Record Video and Webcast – Milestone – 2200th Blog Post – SQL in Sixty Seconds #022 – Video

  1. Hi Pinal

    In Principal database user tables are missing (not appearing ) my boss was asking why it happend, what are causes on this .
    I have checked all logs but no luck can you please suggest me
    How can i find out what are the reasons here .
    Tx

    Like

  2. Hi Pinal – here’s an idea for a 60 second video: The other day after looking at your SQL post on “how to get the top and bottom row in a result set” I had to do something similar, only harder. I had to pull the MAX date from 2 unrelated tables, then find out which of those were actually the most recent, AND be able to pull that single record into a later query as one of the pieces of data in a Select statement.

    (I needed this to find out the most recent update to the database so we could say how recently the inventory counts and values had been last adjusted.)

    I couldn’t get it to work as a subquery so I ended up creating a temp variable table, then querying that temp variable for it’s max record. Code follows:

    BEGIN TRANSACTION

    — create temp variable table
    declare @TempMaxUpdate TABLE (LastUpdate smalldatetime)

    — Find most recent Purchase Order Date
    Insert into @TempMaxUpdate
    select max(ReceivedDate) LastUpdate
    from Porders2

    — Find most recent Work Order Date
    Insert into @TempMaxUpdate
    select MAX(WoMaster.CompletedTime) LastUpdate
    from WoMaster

    Then in my following select statement I can just include as an item the MAX of those 2 values now in the temp variable like so:

    INSERT INTO [Inventory_Totals]
    (ReportDate, LastTransactionDate, ItemCount, PartsCount,TotalCost_QtyOnHand, TotalCost_MinOnHand, TotalCost_MaxOnHand, SourceDB, Notes)
    SELECT
    GETDATE()
    ,(select MAX(LastUpdate) from @TempMaxUpdate)
    ,COUNT(*)
    ,SUM(QuantityOnHand)
    ,SUM(QuantityOnHand * CurrentCost)
    ,SUM(MinimumOnHand * CurrentCost)
    ,SUM(MaxOnHand * CurrentCost)
    ,DB_NAME()
    ,’Test of InvTot_ID auto fill in’
    FROM Parts
    GO
    COMMIT TRANSACTION

    And there you have it. An “on the fly” method of grabbing non-related data and then pulling from that set as needed. And as a temp variable I think it’s destroyed after the commit as well.

    Like

  3. Pingback: SQL SERVER – Weekly Series – Memory Lane – #039 | Journey to SQL Authority with Pinal Dave

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s