I have done it by using UNION group by of parent projects with projects.

I have found solution,

using functions substring and charindex

Thanks

Thanks noeld,

I have added as another topic - CTE, view and Crystal.

Thank you Grant Fritchey

Busy with another urgent issue. I will have fun later.

Thanks!!

Thank you Jason for the reply.

I can't find examples CTEs within views. Tried to create - CTE has to be started with WITH and semicolon before! I am really...

Thank you noeld for your reply!!

I've made it yesterday and tested. It works well.

WITH Steps_CTE

AS

(

SELECT from_step_id, to_step_id, 1 as rlevel

FROM all_steps_vw

WHERE from_step_id = 0

UNION ALL

SELECT CTE.to_step_id,...

Thanks Ramesh for your time and sending the query! I appreciate it very much. I am struggling with CTE... May I explain once again what I need to do?

I...

Thank you ALZDBA for important info, but I am afraid I can't use this Assistant. I need to solve this problem by creating views in SQL Server.

Thank you for reply Ramesh. I will read regarding Common Table Expressions.