116 reputation
5
bio website
location
age 36
visits member for 2 years, 4 months
seen Mar 22 at 6:26

Currently employed as a Senior Analyst focusing on Supply Chain and Replenishment. Mostly looking after rapid prototyping and proof of concepts, but meddling in data modeling, reporting and process flows.

Have also worked on the Unreal Tournament series as a Level Designer and contributer to Unreal Developers Network.

Current Free as in Beer project:

http://code.google.com/p/wwwsqldesigner/

Question I am proud to ask How can an SQL query return data from multiple tables

Answer I am most proud of: Creating query that returns id if condition is matched in rows from two tables


Sep
24
awarded  Autobiographer
Aug
5
awarded  Scholar
Aug
5
accepted Application Logic Vs DB Triggers for database cleaning
Aug
5
comment Application Logic Vs DB Triggers for database cleaning
@tdammers I haven't enforced keys in the database, like I said, I built it in a very hurried fashion :(
Aug
5
awarded  Supporter
Aug
3
comment Application Logic Vs DB Triggers for database cleaning
Good point, I do a lot of my heavy lifting in this app via a schedule, but the users wanted to see data vanish immediately and as the tables are in fact related multiple one to many relationships, I figured a simple trigger might work cleanly.
Aug
3
awarded  Editor
Aug
3
revised Application Logic Vs DB Triggers for database cleaning
added 279 characters in body
Aug
3
awarded  Student
Aug
3
asked Application Logic Vs DB Triggers for database cleaning