Ok, here's the full query. It took 6 minutes 11 seconds to run. Obviouslty this
is far too slow. I'm open to suggestion:

SELECT CAST(0 AS bit) AS checked,
       '                    ' AS invoiceid,
       '                    ' AS ISCI,
       '  ' AS dayofweek,
       '          ' AS Phone,
       doc.id AS docid,
       doc.station,
       doc.client,
       mo.show_title,
       mo.order_rate AS gross,
       mo.program_name,
       mo.order_qty AS ordqty,
       mo.id AS line_id,
       mod.actual_air_date,
       mod.actual_air_time
  FROM Document doc
  JOIN Client cl ON cl.id = doc.client
  JOIN Station st ON st.id = doc.station
  JOIN Media_Order mo ON mo.Document = doc.id
  JOIN Show_title sht ON sht.id = mo.show_title
  JOIN Media_Order_Detail mod ON mod.Media_Order = mo.id
  WHERE st.id = 733 AND
        actual_air_date between '2005-07-01 00:00:00.000' and '2005-07-31 00:00:00.000

  ** The WHERE clause would normally be built on the fly.

'

>You're welcome.
>
>>All works fine now. Thanks!
>>
>>
>>
>>>There're no boolean type in T-SQL. The closest one is bit.

>>>SELECT CAST(0 AS bit) AS checked,
>>>...
>>>

>>>>Ok, now it doesn't like the 'FALSE'. Whats the correct way to
>>>>create a boolean column?