Connect by prior = Oracle and Sqlserver ????

how can j do the same fonction with Sqlserver ?Thank

Find more posts tagged with

Comments

Message from Marie Lindsay <<A HREF="mailto:marie@opentext.com">marie@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

There's no equivalent "easy way" in SQL Server -- you need to write a stored procedure. I believe you'll find other topics about this in this discussion -- maybe do a search for "connect by".

-----Original Message-----
From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, October 01, 2002 2:51 AM
To: eLink Recipient
Subject: Connect by prior = Oracle and Sqlserver ????

Connect by prior = Oracle and Sqlserver ???? Posted by Accor.fr1 (Violette, Ludovic) on 10/01/2002 03:50 AM

how can j do the same fonction with Sqlserver ?
Thank

Magnus_Salgo_(IDNordicAdmin_(Delete)_2300172)

What version of SQLserver ?I think at least in the SQLserver 7 days you needed to do some Stored procedures. I think it is good stated in the SQLserver online help.RegardsMagnus@ids.se