SQLServerQuery | SQLServerCentral

SQLServerQuery

Forum Replies Created

Viewing 2 posts - 1 through 3 (of 3 total)

Reply To: Parsing XML data into multiple Datasets
Posted this question elsewhere and got a great answer:
https://learn.microsoft.com/en-us/answers/questions/1153653/parsing-xml-data-into-multiple-datasets.html#comment-1154683
```
     SELECT
       ROW_NUMBER()OVER(ORDER BY Caseid.value('@caseid[1]', 'int')) AS RowID,
 ...
```
January 6, 2023 at 4:07 pm

#4134592
Reply To: Identify mismatched pair sequences in two datasets

Hi Jonathan AC Roberts,
Thanks for your input. Your LEAD/LAG CTE Solution was pretty much exactly what I wanted.
Thanks

January 1, 2023 at 10:19 am

#4132388

Viewing 2 posts - 1 through 3 (of 3 total)