Viewing 10 posts - 31 through 40 (of 40 total)
How are you interfacing with your backend? Are you using pass through queries or ADODB recordsets or what?
September 5, 2008 at 12:39 pm
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...
August 29, 2008 at 1:38 pm
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...
August 29, 2008 at 1:17 pm
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.
July 25, 2008 at 11:10 am
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...
July 22, 2008 at 6:24 am
Cool. Thanks.
I was hoping there would be some nicer solutions, but these will do!
July 21, 2008 at 9:36 am
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?
July 21, 2008 at 8:26 am
Thanks Jason! That less than on the identity really blew my mind.
July 8, 2008 at 9:38 am
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...
July 8, 2008 at 9:12 am
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,...
July 8, 2008 at 7:55 am
Viewing 10 posts - 31 through 40 (of 40 total)