ArJdbc::MsSQL::LimitHelpers::SqlServer2000ReplaceLimitOffset

    # File lib/arjdbc/mssql/limit_helpers.rb, line 17
17:         def replace_limit_offset!(sql, limit, offset, order)
18:           if limit
19:             offset ||= 0
20:             start_row = offset + 1
21:             end_row = offset + limit.to_i
22:             find_select = /\b(SELECT(?:\s+DISTINCT)?)\b(.*)/m
23:             whole, select, rest_of_query = find_select.match(sql).to_a
24:             if (start_row == 1) && (end_row ==1)
25:               new_sql = "#{select} TOP 1 #{rest_of_query}"
26:               sql.replace(new_sql)
27:             else
28:               #UGLY
29:               #KLUDGY?
30:               #removing out stuff before the FROM...
31:               rest = rest_of_query[/FROM/=~ rest_of_query.. 1]
32:               #need the table name for avoiding amiguity
33:               table_name = LimitHelpers.get_table_name(sql)
34:               #I am not sure this will cover all bases.  but all the tests pass
35:               new_order = "ORDER BY #{order}, #{table_name}.id" if order.index("#{table_name}.id").nil?
36:               new_order ||= order
37: 
38:               if (rest_of_query.match(/WHERE/).nil?)
39:                 new_sql = "#{select} TOP #{limit} #{rest_of_query} WHERE #{table_name}.id NOT IN (#{select} TOP #{offset} #{table_name}.id #{rest} #{new_order}) #{order} "
40:               else
41:                 new_sql = "#{select} TOP #{limit} #{rest_of_query} AND #{table_name}.id NOT IN (#{select} TOP #{offset} #{table_name}.id #{rest} #{new_order}) #{order} "
42:               end
43: 
44:               sql.replace(new_sql)
45:             end
46:           end
47:           sql
48:         end