Database

andyharman wrote:

select * from MyTable where convert(varchar(6), (Year*12)+sMonth) between '200706' and '200806'

select table3.description,
    convert(varchar, table1.blId) + '.' + convert(varchar, table2.bl2Id) as TheIds
from table3
inner join table1
  on table3.description like table1.blDesc + '.%'
inner join table2
  on table3.description like '%.' + table2.bl2Desc
order by table1.blId, table2.bl2Id

select latest_order.customer_id AS cust_id
      latest_order.order_id AS order_id,
      customers.fname AS fname,
      customers.lname AS lname,
      latest_order.order_date AS order_date,
      latest_order.order_status AS order_status
from customers
inner join (
   select lastest_order_id.customer_id, lastest_order_id.order_id,
      lastest_order_id.order_date, latest_order_id.order_status
   from (
      select customer_id, max(order_id)
      from cust_order
      group by customerId
   ) as lastest_order_id
   inner join cust_order
   on cust_order.order_id = lastest_order_id.order_id
) as latest_order
on latest_order.customer_id = customers.customer_id