Skip to content

Tag: sql

Pivot Table with Dynamic

My quest might be answered in somewhere here but I couldn’t find. So, sorry if I asked in vain. I have a Table that’s populate automatically with precisely date/time in SQL Server and looks like …

Update referencing on subquery (sqlite)

I have a table with md5 sums for files and use the following query to find the files which exist in one hashing-run and not in the other (oldt vs newt): SELECT * FROM md5_sums as oldt WHERE NOT …