I want some Moore

# re: Converting TSQL/C#/VB Code to HTML

Good link ... very nice find!
- Jeff

# re: Converting TSQL/C#/VB Code to HTML

SELECT r.rollout_id,
r.ROLLOUT_TYPE,
r.rollback_from,
r.description,
r.rollout_plan_ticket,
r.parent_rollout_id,
r.machines_so_far,
r.machines_to_roll,
r.HAS_STARTED_ROLLBACK,
r.skip_staging,
r.skip_approval,
r.skip_qa,
r.build_label,
r.force_rollout,
r.train_number,
r.build_number_code,
bd1.code_value as code_tag,
r.build_number_xsl,
bd2.code_value as xsl_tag,
r.TC_ID,
cu.email as conductor_login,
cu.first_name as conductor_f,
cu.last_name as conductor_l,
r.RE_ID,
ru.email as release_login,
ru.first_name as release_f,
ru.last_name as release_l,
r.start_time,
r.include_machine_list,
r.exclude_machine_list,
r.rollout_command,
r.rollback_command,
r.rollout_command2,
r.rollback_command2,
r.rollout_success_match,
r.rollback_success_match,
r.status_id,
rs.status_name,
r.plan_id,
pl.plan_name,
r. pool_id,
p.DELIVERABLE_NAME,
p.cal_pool_name,
p.pool_type_id,
r.LAST_MODIFIED_DATE,
p.staging_timeout,
p.runtask_timeout,
p.odb_name,
p.qa_approval_req,
pt.pool_category,
val.TASK_COMMAND
FROM tr2_build_detail bd1,
tr2_build_detail bd2,
tr2_rollout r,
tr2_rollout_status rs,
tr2_plan pl,
tr2_pool p,
tr2_user cu,
tr2_user ru,
tr2_pool_type pt,
TR2_POOL_TASK val,
TR2_TASK task
WHERE (rs.status_id(+) = r.status_id) AND (pl.plan_id(+) = r.plan_id) AND
(p.pool_id(+) = r.pool_id) AND (cu.user_id = r.TC_ID) AND
(ru.user_id = r.RE_ID) AND
(bd1.build_number(+) = r.build_number_code) AND
(bd2.build_number(+) = r.build_number_xsl) AND
(pt.pool_type_id(+) = p.pool_type_id) AND
(val.pool_id(+) = p.pool_id) AND (task.task_id(+) = val.task_id) AND
(task.task_name = 'ValidateInternals' or task.task_name is null) AND
(r.parent_rollout_id = 0 or r.parent_rollout_id = null) AND
r.status_id =
(select status_id from tr2_rollout_status where status_name = :1) AND
r.start_time > :2 AND cu.email = :3

# re: Converting TSQL/C#/VB Code to HTML

and the point of this select is?