SQL SERVER – Building Interactive Reports in Quick Moments – From CSV to Excel Pivot Table – A Conversation turned to Webinar

“I have text files and I need to create interactive reports for my boss – do you have few minutes of time right now? Let us discuss.”

SQL SERVER - Building Interactive Reports in Quick Moments - From CSV to Excel Pivot Table - A Conversation turned to Webinar csv

I often get questions from people who are new to technology and struggling to get something done. However, this time it was not a question from any beginner. This question was from an expert – a friend and an excellent technologist. Wiqar and I have known each other for a long time and often discuss various technologies. He works at expressor Technologies  as a product manager and has built the complete product using .NET framework (woohoo!).

Solarwinds

I received his message on Messenger and my reaction was “yeah, let us discuss it.” Well, we talked for about an hour and ended up with a fantastic outcome. When we were done with our conversation we realized that we had multiple technologies and ended up one great resolution. We did not exactly know what his boss needed so we wanted to build a report in such a way that his boss can customize it and generate  new reports.

Wiqar and I had a great experience while discussing this integrating/reporting issue. We live around 20,000 KM away from each other and are separated by a 12 hour time difference. He works in .Net predominantly and I work on SQL Server. He has built a product which natively connects with SQL Server, Excel, Powerpoint as well other technologies like QlikView, Mellisa Data etc. I am glad to have such a wonderful friend. While we were talking about what a good experience we had, he suggested that we should convert our friendly discussion into a quick learning experience. I agreed with him right away.

This webinar is not going be like a usual webinar. This is a conversation between two friends in a real world environment. We are going to keep the real problem in front of us and build reports from CSV in only a few minutes. We will see how an innocent looking CSV becomes an interactive report. Together we will be discussing the subject in webinar format. I hope you will enjoy our conversation and we will be looking forward to your questions and additional feedback during the seminar.

Conversation of Wiqar and Pinal CSV to Interactive Report
Feb 16, 2pm EST – Register at https://t.co/EFsfd27L

UPDATE: I have embedded the video of the conversation over here.

[Original poster have removed the video]

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

Solarwinds
Previous Post
SQLAuthority News – Business Intelligence features of SQL Server 2012 RC0 – Download Virtual Machine
Next Post
SQL SERVER – T-SQL Errors and Reactions – SQL in Sixty Seconds #002 – Video

Related Posts

9 Comments. Leave new

  • Hi Pinal,

    Good morning,

    It is not opened. after registration also it will not show the conversation. Please check it out.

    Reply
  • Pinal,

    after clicking the link it shows like this

    “Come Back Later
    This Webinar is not yet open to attendees. Please come back at the scheduled time below.

    expressor 3.5.2 GA Webinar with guest speaker Pinal Dave
    Thursday, February 16, 2012 2:00 PM – 3:00 PM EST”

    Reply
  • Hi Pinal,

    Ok i’ll wait for that,

    Thanks for your reply.

    Can i ask one help..???

    Reply
  • Hi pinal,

    can you please help me in this,
    i have one scenario

    having table like this

    (1,’AAA’,’BBB’,’CCC’),
    (2,’DDD’,’EEE’,’FFF’),
    (3,’GGG’,’HHH’,’III’),
    (4,’AAA’,’BBB’,’CCC’),
    (5,’DDD’,’EEE’,’FFF’),
    (6,’GGG’,’HHH’,’III’),
    (7,’AAA’,’BBB’,’CCC’),
    (8,’DDD’,’EEE’,’FFF’),
    (9,’JJJ’,’KKK’,’LLL’),
    (10,’JJJ’,’KKK’,’LLL’)

    desired result:-

    1 GroupA
    4 GroupA
    7 GroupA
    2 GroupB
    5 GroupB
    8 GroupB
    3 GroupC
    6 GroupC
    9 GroupD
    10 GroupD

    Reply
  • bhupendra tailor
    February 17, 2012 6:26 pm

    Hi pinal,

    Please can send me simple example to written a trigger.

    Thanks.

    Reply
    • Hi Ganesh,

      Try the following code… it must work…..

      declare @id1 int,@grps varchar(150),@i int,@TXT VARCHAR(15)
      DECLARE @TBL TABLE(ID INT,GROUPS VARCHAR(150),GROUP_NAME VARCHAR(150))

      set @i=65
      SET @TXT=’GROUP’

      declare result cursor for
      SELECT t.id, t.g1+’,’+t.g2+’,’+t.g3 as Groups from grouptest t with(nolock)
      OPEN result
      fetch next from result into @id1,@grps
      WHILE(@@FETCH_STATUS=0)
      BEGIN
      IF EXISTS(SELECT 1 FROM @TBL WHERE GROUPS=@grps)
      BEGIN
      INSERT INTO @TBL(ID,GROUPS,GROUP_NAME)
      (SELECT TOP 1 @id1,@grps,GROUP_NAME FROM @TBL WHERE GROUPS=@grps)
      END
      ELSE
      BEGIN
      INSERT INTO @TBL(ID,GROUPS,GROUP_NAME)
      SELECT @id1,@grps,(@TXT+CONVERT(VARCHAR,CHAR(@i)))
      SET @i=@i+1
      END

      fetch next from result into @id1,@grps
      END
      CLOSE RESULT
      DEALLOCATE RESULT

      SELECT ID,GROUP_NAME FROM @TBL
      ORDER BY GROUP_NAME

      Thanks,
      Velmurugan P

      Reply
  • Pinal, I’d love to watch this embedded video, but it seems to be set to private. Help please?

    Reply

Leave a Reply

Menu