CREATE TABLE "Service"
("ServiceId" INT IDENTITY PRIMARY KEY,
	"ParentId" INT NULL,
	"ServiceName" VARCHAR(512) NOT NULL);

CREATE TABLE "Prog"
("ProgId" INT IDENTITY PRIMARY KEY,
	"ServiceId" INT NOT NULL);

WITH ProgAndParentAll (ServiceId, ParentId, ServiceName)
	AS
	(
		SELECT ServiceId, ParentId, ServiceName FROM Service
		WHERE ServiceId IN (SELECT ServiceId FROM Prog)
		UNION ALL
		SELECT t1.ServiceId, t1.ParentId, t1.ServiceName FROM ProgAndParentAll, Service t1
		WHERE t1.ServiceId = ProgAndParentAll.ParentId  
	)
   SELECT * FROM ProgAndParentAll