About Me

I grew up in a suburb of Milwaukee in Southeastern Wisconsin. I come from a family with eight kids, so I’m used to the chaos that the IT world throws at us! I graduated from Franciscan University in Steubenville, OH in 2008 with a degree in math and economics. Since then I’ve worked in the Milwaukee area for a bank, a software company, and I’m currently working for an online retailer. I’ve been happily married since 2009, and my wife and I are the proud parents of three young children. We belong to Saint Frances Cabrini parish and try our best be good Catholics, growing closer to God as we live. My relationship with God and my family are the two most important parts of my life, but in my little leftover free time I enjoy fishing, microbrews, cheering on the 49ers and Bucks, and I’m trying to get into bow hunting.

3 thoughts on “About Me”

  1. Dear,

    I am not implementing email database mail sending from SQL SERVER and I found your great sample of Send Database Mail in HTML Table Format from SQL Server which I could not find this function inside PROCEDURE [dbo].[SendDBEmailwithTabularQuery] for sql creating SplitStirng function in SELECT s FROM DBMaint.dbo.SplitString(@fieldlist,’|’)

    please help to provide the create function syntax for SplitString so that I can complete task.

    thank you very much.

    thara

    Like

    Reply

      • I have used your method to not email an SSRS subscription if the rows are empty, but I’m not sure where to put the Truncate Table DBMaint.dbo.BCS_LowStockLevel10171. Does it go someplace inside the steps below in the modified SQL Agent job step1??

        SELECT TOP 1 1
        FROM DBMaint.dbo.BCS_LowStockLevel10171

        IF @@ROWCOUNT > 0
        BEGIN
        EXEC [LW_ReportDB].dbo.AddEvent @EventType = ‘TimedSubscription’,
        @EventData=’b2ab547d-724b-4c12-abae-58e83ee1ed13′
        END

        Like

Leave a comment