Tag Archives: T-SQL

T-SQL Tuesday #168–Using Window Functions

Posted on November 14, 2023 by way0utwest

I am the host for T-SQL Tuesday this month, and I hope that a lot of people like the topic. This idea actually came to me earlier this year when I happened to see someone ask about a T-SQL problem … Continue reading →

Posted in Blog | Tagged , , , | 1 Comment

T-SQL Tuesday #168 – Mature Window Functions

Posted on November 7, 2023 by way0utwest

It’s time for T-SQL Tuesday and I’m hosting this month. I usually do one a year, just because I can and being responsible for a month keeps me engaged in the party. This month my invitation is on Window functions … Continue reading →

Posted in Blog | Tagged , , | 16 Comments

Creating a Self Referencing FK in a CREATE Statement–#SQLNewBlogger

Posted on November 6, 2023 by way0utwest

I had written about a FK in a CREATE TABLE statement recently, but the second half of this was that after the original question, the person asked if this would also work for a self-referencing FK. It does, and I … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

Adding a Foreign Key in the CREATE TABLE statement–#SQLNewBlogger

Posted on October 30, 2023 by way0utwest

I had someone ask this question recently and had to double check the syntax myself, so I thought this would make a nice SQL New Blogger post. Another post for me that is simple and hopefully serves as an example … Continue reading →

Posted in Blog | Tagged , , | 2 Comments