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!

Beceriler: ColdFusion

Daha fazlasını gör: 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

İşveren Hakkında:
( 78 değerlendirme ) Kuranda, Australia

Proje NO: #125697



Look at PM

%selectedBids___i_period_sub_7% gün içinde 70%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(81 Değerlendirme)

Bu iş için 4 freelancer ortalamada $63 teklif veriyor


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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)

See PMB for more information. Thanks.

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

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.

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)