Run Microsoft .SQL within CI Model

[eluser]Ben Bowler[/eluser]
If anyone's interested I slept on it and came up with this ridiculously simple function:

Code:

/**
*
* Retrieve the results of an SQL file
*
*/

    function runsql($file = '')
    {
        
        $this->db_download = $this->load->database('download', TRUE);
        
        $sql = file_get_contents($file);
        
        $query = $this->db_download->query($sql);
        $result = $query->result();
        
        return $result;
        
    }