sql

Wow. I've seen some odd behavior in SQL before, but this one seems to defy logic. Maybe I'm missing something obvious. It hinges on a fairly simple logic statement: Given that a record exists in one table, then a matching record either exists in another table or it does not exist in that...

I have a reporting system that depends on triggers in the production database for a bunch of different tables that, when changed, drop a small change record in a table. This table is monitored by another process that looks up the records that have changed and saves them to the reporting...

I'm in the middle of a monstrous upgrade of our timecard tracking software (not my area of expertise, but it got dumped in my lap). I keep getting errors running the scripts that are auto-generated by the upgrader the vendor provided. The scripts continue for a while despite the errors, but...

Hi, hope someone can help. I have a Crystal report that is basically a list of route cards (sometimes known as works orders or job cards). I need to do some analysis on which customers these route cards were for. Usually, these route cards are linked to a contract which makes it easy to...

Hi! We have users, and they are kept in a table. We have items, which have statistics and are kept in another table (actually a set of tables related by foreign keys). As users play our game, they collect items, and they can have multiple copies of an item. I was thinking that we'd need a...

Hi, I have a visual basic 6 program that reads an access table. I need to select records by date. I thought this would be simple, but it seems not. I'm using DAO, erm...i've no idea what that means so i'll leave that there so i don't embarrass myself further. Here's my vb code to read the...

I have a database that was set up as case sensitive and needs to be changed to case insensitive. The original collation for the db was SQL_Latin1_General_CP1_CS_AS and I need to change it to SQL_Latin1_General_CP1_CI_AS. I already did an (alter database <dbname> collate...

Gah! It seems like every time we get our website up, something new happens and it's down again. Here's the short version--I'm interested in opinions of you with more SQL experience-- 1. running website using wordpress. Works great, but a bit unsightly, since we cobbled it together from a plone...

Is there a SQL utility that can show me the actiivty against a database over a certain period of time? I thought something like this would be fairly common but I haven't found anything like it. I am, admittedly, very new at the SQL game.

We're going to morph the JREFwiki into the SkepticWiki in the near future, but I have a little problem... When I created the wiki, I gave the tables a jref_ prefix. I now want to change the prefix on all tables to skep_ Does anyone know if there's a wildcard-type command in SQL that allows...

Hopefully, there is someone who knows how to solve this, I've been working on it for a few hours and I've got myself absolutely nowhere... I have a database (built in MSAcess), it has a series of records (which if I understand databases correctly, that's normal). Each record can be assigned a...