SQL Server recursive query

by

Look into using what is called a CTE (common table expression) (Refer to MSDN document):

;with cteAppointments as (
 select AppointmentID, PersonID, PrevAppointmentID
     from Appointments
     where PrevAppointmentID is null
 union all
 select a.AppointmentID, a.PersonID, a.PrevAppointmentID
     from Appointments a
         inner join cteAppointments c
             on a.PrevAppointmentID = c.AppointmentID
)
select AppointmentID, PrevAppointmentID
    from cteAppointments
    where PersonID = xxx

More Related Contents:

  1. SQL Server query to find all permissions/access for all users in a database
  2. What is the maximum characters for the NVARCHAR(MAX)? [duplicate]
  3. Why use the INCLUDE clause when creating an index?
  4. SQL Server sp_msforeachtable usage to select only those tables which meet some condition
  5. Is it possible to force row level locking in SQL Server?
  6. Regular Expressions in SQL Server servers?
  7. SQL Server GUID sort algorithm. Why?
  8. What happens to the primary key Id when it goes over the limit?
  9. Drop primary key using script in SQL Server database [duplicate]
  10. How to create the linked server for SQL Server 2008 where we have the database from 2000 and 2005
  11. nvarchar(max) vs NText
  12. INFORMATION_SCHEMA vs sysobjects
  13. “Prevent saving changes that require the table to be re-created” negative effects
  14. What are row, page and table locks? And when they are acquired?
  15. Table Valued Function Killing My Query Performance
  16. Insert an image in a column of a table that already has 5 columns
  17. How to get cumulative sum
  18. How to check if a column exists in a SQL Server table
  19. Sql Server string to date conversion
  20. SET versus SELECT when assigning variables?
  21. How to print VARCHAR(MAX) using Print Statement?
  22. Splitting delimited values in a SQL column into multiple rows
  23. SqlDataSourceEnumerator.Instance.GetDataSources() does not locate local SQL server 2008 instance
  24. How to remove accents and all chars a..z in sql-server?
  25. How to update primary key
  26. error when inserting into table having instead of trigger from entity data framework
  27. How to query values from xml nodes?
  28. Case sensitive variables in SQL Server
  29. How to query for Xml values and attributes from table in SQL Server?
  30. How do I move a table into a schema in T-SQL

Leave a Comment