| bio | website | |
|---|---|---|
| location | ||
| age | 35 | |
| visits | member for | 9 months |
| seen | Aug 30 '12 at 13:37 | |
| stats | profile views | 5 |
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
|
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 |