Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SYS_CONNECT_BY_PATH
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

nostalgia
Starting Member

Austria
2 Posts

Posted - 04/05/2013 :  08:54:43  Show Profile  Reply with Quote
What would the same thing look like for SQL Server, using application HP Quality Center?

SELECT CF.CF_ITEM_ID ID, CF.CF_FATHER_ID ParentID, CF.CF_ITEM_NAME ItemName
, LTRIM(SYS_CONNECT_BY_PATH (CF.CF_ITEM_NAME, '\\'), '\\') Path
FROM CYCL_FOLD CF START WITH CF.CF_ITEM_NAME = '@TLProject_Name@'
CONNECT BY PRIOR CF.CF_ITEM_ID = CF.CF_FATHER_ID

Error message: Quality Center cannot run the query because it contains invalid statements.
I still haven't any idea how to accomplish this query in SQL Server.

Bustaz Kool
Flowing Fount of Yak Knowledge

USA
1834 Posts

Posted - 04/05/2013 :  19:23:37  Show Profile  Reply with Quote
What is the thing that you want to be the same as? What is the original system? What is the "SYS_CONNECT_BY_PATH" supposed to accomplish in the original system?

=================================================
There are two kinds of light -- the glow that illuminates, and the glare that obscures. -James Thurber
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000