Posts about “sql”

iTunes Playlist Options Improvement

The feature I’d most like to see added to iTunes “smart playlist” building is the ability to exclude songs based on metadata. I like to listen to music that I haven’t heard in a long time and / or that I haven’t heard very often. The only problem is that when I choose to select

LIMIT and OFFSET in MS SQL Server

LIMIT and OFFSET in MS SQL Server

How to Hack MySQL Paging Functionality into Microsoft SQL Server

SQL

If any of my beloved readers are SQL whizzes, I have a little problem posted on my development blog. I will love you forever if you can give me any ideas …

SQL

Help! If anyone can help me out with this I will severely owe you one. I have this SQL query that I need to return just one more field, and I can’t figure out how to do it. (The query is in the extended text for this entry; click on the icon or the comments

I’m almost ready for a beta release of PoolPlayer. I need to get a better name for it, I know. Right now I’m working on letting the user (or the app) delete a week from the database regardless of whether there are any games associated with that week. It’s not as easy as it sounds. But I should be done soon. Woot!

Beginning

This is going to be a blog for information related to my many projects. Mostly I will probably write about programs I am writing and web development work I am doing, and I imagine this will mainly be a personal blog. I doubt many people will be interested in learning about listview columnheaders or SQL

What Is This?

davidgagne.net is the personal weblog of me, David Vincent Gagne. I've been publishing here since 1999, which makes this one of the oldest continuously-updated websites on the Internet.

bartender.live

A few years ago I was trying to determine what cocktails I could make with the alcohol I had at home. I searched the App Store but couldn't find an app that would let me do that, so I built one.

Hemingway

You can read dozens of essays and articles and find hundreds of links to other sites with stories and information about Ernest Hemingway in The Hemingway Collection.