Help with streamlining SQL queries


I have two pages (scripts) that need tightening up. My SQL is pretty basic.

First script is an address book. It has groups too. Currently 154 lines of code (including output code). I think I would like to put this in the session scope so when my user logs in their address book is created. If they add / edit / delete their address book it would need to be recreated. Pretty straight forward. I would like to try this myself and have whoever wins this bid help me get it right.

Next script is a summary panel. Currently 356 lines of code (including output code). The summary pulls data in from a few tables. As my SQL isn't so good I really need to make one big query instead of all these little ones. Again, I would like to have a bit of a go at this myself and get your help to get it the best it can be.

Thanks for your bids!

Habilidades: Cold Fusion

Veja mais: streamlining sql queries, need sql help, i need help with my book, forward think, t-sql with, t-sql in, edit my book, think straight, t-sql;, sql, sql script , sql queries, sql data, Sql code, sql c, get sql help, C# SQL, best wins, sql created, fusion help, summary book, help data, little sql, queries sql, edit output

Acerca do Empregador:
( 78 comentários ) Kuranda, Australia

ID do Projeto: #125697

Concedido a:


Look at PM

$70 USD em 4 dias
(81 Comentários)

4 freelancers estão ofertando em média $63 para esse trabalho


ready to help, i'm specialized in php & mysql

$30 USD em 1 dia
(0 Comentários)

See PMB for more information. Thanks.

$100 USD in 6 dias
(0 Comentários)

Hi, I've got a lot of experience in writing and optimizing queries. I've also got MySQL, MS SQL and ColdFusion MX7 servers running on my computer and ready to work for you.

$50 USD in 2 dias
(0 Comentários)