“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.”
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!).
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)
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.
Hi Ganesh,
If you are registered you will get email soon with the link.
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”
Ganesh,
That is exactly I wrote in my blog post.
Hi Pinal,
Ok i’ll wait for that,
Thanks for your reply.
Can i ask one help..???
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
Hi pinal,
Please can send me simple example to written a trigger.
Thanks.
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
Pinal, I’d love to watch this embedded video, but it seems to be set to private. Help please?