How are you interfacing with your backend? Are you using pass through queries or ADODB recordsets or what?

Replacing a cursor with a temporary table, a select max(id) and delete max(id) style approach appears to having everything running correctly and in order.

You can consider this issue solved (although...

Ok, I have 4 prints in the code, and they returned out of order...

Changing them to selects, they're in order, but one of them doesn't show. It literally is

SELECT 'END'

I...

Cool! Thanks guys.

Unfortunately UDFs don't allow for temporary tables, but i'm going to be looking into use table varaibles in a bit.

I'm an intern that's working on a database for internal use that documents various aspects of a business. Some of the data collection is automated, but some of it is...

Cool. Thanks.

I was hoping there would be some nicer solutions, but these will do!

Sweet, thanks.

That should work because i'm doing this in a small database with few users. But is there a way to do it that isn't a triangular join?

Thanks Jason! That less than on the identity really blew my mind.

Is your SQL database on a remote server? Or is SQL on the local machine so you need to create all the database tables the first time the program is...

partridgetim ,

The issue with using something like TeamName as your primary key is other tables will use the primary key to reference the team in the team table. For example,...