Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nostalgia
Starting Member
2 Posts |
 Posted - 2013-04-05 : 08:54:43
|
| 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_IDError 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
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2013-04-05 : 19:23:37
|
| 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 |
 |
|
|
|
|
|
SYS_CONNECT_BY_PATH