So what is new at Gmail today you ask! It’s Web Clips. What is Web Clips?
“Web Clips shows you news headlines, Gmail tips, blogs, any RSS and Atom feed, relevant sponsored links, and more -- right at the top of your inbox and messages. Receive updates from your favorite sites without having to leave Gmail! “
I logged into one of my Gmail accounts today to find out that Gmail has a new feature. A bit more fiddling with it and I was on my way to use the new feature with feeds that I wanted to see. But why bother with this feature when Google already had Google Reader ? If you are like me then you probably subscribe to a lot of feeds and then when the week is busy, you just don’t get time to read, even the feeds that you really care about and want to read. So at times I don’t get to read any feeds at all.
I use Gmail a lot, when I think email, I think Gmail. Even my work email is mirrored to Gmail account. So now using Web Clips I can subsribe to the feeds that are on my top priority reading list and just read them while still using Gmail. I don’t have to switch windows or open new ones. It’s cool!
What’s the down side? It will be distracting me from my real work sometimes. People write catchy headlines and then we are tempted to read what they are talking about. So be careful, don’t get distracted.
One feature I will like is auto rotate news items on a timely basis. I mean keep it 5–10 seconds and give users the option to control that feature. At the moment I either have to click on next icon or I see another news item when I refresh the page.
Technorati Tags: tools, email, web tools, feed reader, Google, GmailGuys, I have a table by name "TblRecursive" which has following data ID, Name, ParentID 1, A, 0 2, B, 1 3, C, 2 4, D, 2 5, E, 1 Using the above data I just want to generate a result as below A A\B A\B\C A\B\D A\E Can you help in writing a query for this?My Solution: We can achieve this by calling a "User Defined Function (UDF) recursively". Let me show how to do that with a working example. Table creation:
Create table tblEmployeeInfo
(
EmpId int primary key,
EmpName varchar(30),
MgrId int
)
Insert test data into it:
Insert into tblEmployeeInfo values(1, 'Director', null)
Go
Insert into tblEmployeeInfo values(2, 'Joint Director', 1)
Go
Insert into tblEmployeeInfo values(3, 'Secretary', 2)
Go
Insert into tblEmployeeInfo values(4, 'Joint Secr.,', 3)
Go
Insert into tblEmployeeInfo values(5, 'Legal Advisor', 1)
Go
UDF for your requirement:
Create function GetEmpPath ( @pEmpid int ) Returns varchar(8000)
As
Begin
Declare @intMgrid int
Declare @strEname varchar(500)
Declare @strPath varchar(500)
Select @intMgrid = mgrid, @strEname = empname From tblEmployeeInfo where
EmpId = @pEmpid
If (@intMgrid is null)
Begin
Set @strPath = @strEname
End
Else
Set @strPath = dbo.GetEmpPath(@intMgrid) + '\' + @strEname
return @strPath
End
Go
Test the code:
Select dbo.GetEmpPath(empid) as Hierarchy, empname as 'Employee Name' from tblEmployeeInfo