This is Jason who is continuing to masquerade as a guest.

BUY Foot Care Cream ONLINE WITHOUT PRESCRIPTION, I'm going to let you into a dirty little secret...I've written a lot of SQL during my career. Fast shipping Foot Care Cream, This admission almost sounds like heresay in these days of DDD, BDD etc, purchase Foot Care Cream online. Order Foot Care Cream no prescription, but it's still an incredibly useful skill to have. Anyway a lot of our development is performed in an environment where OR/M tools such as NHibernate are not an option so we need to rely on such traditional techniques more often than I would like.

Today someone came to me and said "So I have a route, where can i buy Foot Care Cream online. Where can i buy cheapest Foot Care Cream online, And a route can have jobs. And each job has a status, BUY Foot Care Cream ONLINE WITHOUT PRESCRIPTION. I need to show for each route the number of jobs that have a particular status and which don't have the status".

What they are really asking for is to pivot the data - the rows need to be converted to columns, order Foot Care Cream online overnight delivery no prescription. Foot Care Cream for sale, The technique that I employed to solve this problem uses a combination of a case statement and an aggregate function to pivot the data. More explicitly the case statement is used to bucket the data and the aggregate function to do something to that bucket, buy Foot Care Cream without prescription. Comprar en línea Foot Care Cream, comprar Foot Care Cream baratos, Normally I would use a COUNT but the RDBMS in question (SQL Anywhere) throws a warning when a null is aggregated so I used SUM instead.

What was interesting when I looked at how I presented my solution to my colleague was that the format is not too dissimilar to what I might do with a more fully featured language than SQL (yes I know there's no tests but it's pretty close to a specification as it's a paint by numbers solution). Anyway here's the SQL:

create table route (id int)

create table job (id int, buy cheap Foot Care Cream no rx, Buy Foot Care Cream without a prescription, route_id int, status varchar(1))

insert into route (id) values (1)
insert into route (id) values (2)

insert into job (id, buy Foot Care Cream from canada, Online buy Foot Care Cream without a prescription, route_id, status) values (1, kjøpe Foot Care Cream på nett, köpa Foot Care Cream online, Foot Care Cream for sale, 1, 'A')
insert into job (id, buy cheap Foot Care Cream, Where to buy Foot Care Cream, route_id, status) values (2, ordering Foot Care Cream online, Order Foot Care Cream from United States pharmacy, 1, 'B')
insert into job (id, order Foot Care Cream no prescription, Foot Care Cream samples, route_id, status) values (3, buy Foot Care Cream online cod, Foot Care Cream gel, ointment, cream, pill, spray, continuous-release, extended-release, 1, 'A')
insert into job (id, where can i buy Foot Care Cream online, Where to buy Foot Care Cream, route_id, status) values (4, where can i order Foot Care Cream without prescription, Buy Foot Care Cream ONLINE WITHOUT prescription, 2, 'A')
insert into job (id, buy Foot Care Cream from canada, Buy generic Foot Care Cream, route_id, status) values (4, australia, uk, us, usa, Order Foot Care Cream online overnight delivery no prescription, 2, 'B')
insert into job (id, buy no prescription Foot Care Cream online, Buy Foot Care Cream from mexico, route_id, status) values (5, Foot Care Cream over the counter, Buy Foot Care Cream without prescription, 2, 'C')

select
  route_id, where can i buy cheapest Foot Care Cream online, Buy Foot Care Cream no prescription,
  sum(case when status = 'A' then 1 else 0 end) sum_a,
  sum(case when status <> 'A' then 1 else 0 end) sum_not_a
from
  route r
  inner join job j on r.id = j.route_id
group by
  route_id
order by
  route_id

, canada, mexico, india. Online buy Foot Care Cream without a prescription. Buying Foot Care Cream online over the counter. Purchase Foot Care Cream online. Foot Care Cream trusted pharmacy reviews. Purchase Foot Care Cream. Comprar en línea Foot Care Cream, comprar Foot Care Cream baratos. Where can i find Foot Care Cream online.

Similar posts: BUY Quinine ONLINE WITHOUT PRESCRIPTION. BUY Female Pink Viagra ONLINE WITHOUT PRESCRIPTION. Rx free Diltiazem HCL. Order Misoprostol online c.o.d.
Trackbacks from: BUY Foot Care Cream ONLINE WITHOUT PRESCRIPTION. BUY Foot Care Cream ONLINE WITHOUT PRESCRIPTION. Rx free Foot Care Cream. Foot Care Cream for sale. Buying Foot Care Cream online over the counter.

Jason Grundy