Home Forums SQL Server 2008 T-SQL (SS2K8) Calculate time difference between two related visitors without using cursor RE: Calculate time difference between two related visitors without using cursor

  • valeryk2000 (9/27/2016)


    I do not know what would be the better way to present a simple table with 7K+ records (Excel file). The table has 2 columns, ID and Arrival DateTime. Sorted by ID and then by Arrival DateTime. In the past I wrote a code with double cursors iterating over each ID (not for this table and not for this task). I thought that there may be a better way to do it.

    Thanks

    Now, based on the sample data, what should the results look like?