Tag Archives: T-SQL

2020 Advent of Code – Day 5

Posted on May 17, 2021 by way0utwest

This series looks at the Advent of Code challenges. As one of my goals, I’m working through challenges. This post looks at day 5. I’m going to do this one in Python here, though I did solve it in other … Continue reading →

Posted in Blog | Tagged , , | Comments Off on 2020 Advent of Code – Day 5

Basic XML Queries–#SQLNewBlogger

Posted on May 10, 2021 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I ran across a question recently on querying an XML document. While I think XML is a pain and … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Basic XML Queries–#SQLNewBlogger

Basic OFFSET–#SQLNewBlogger

Posted on April 21, 2021 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. The other day I saw an article on the OFFSET clause in a SELECT. I had seen this come … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

Basic Fetch and Offset Experiments–#SQLNewBlogger

Posted on March 29, 2021 by way0utwest

I’ve never used the FETCH or OFFSET commands for pagination, but I have heard of them. I ran across them recently and decided to experiment a bit. One note: I have seen notes about performance, so before you do more … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Basic Fetch and Offset Experiments–#SQLNewBlogger