X-Received: by 10.50.142.103 with SMTP id rv7mr11779060igb.2.1447947450904; Thu, 19 Nov 2015 07:37:30 -0800 (PST)
X-Received: by 10.140.108.195 with SMTP id j61mr170972qgf.7.1447947450739; Thu, 19 Nov 2015 07:37:30 -0800 (PST)
Path: csiph.com!xmission!news.glorb.com!i2no5064690igv.0!news-out.google.com!f23ni648qge.0!nntp.google.com!f78no823984qge.1!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ms-sqlserver
Date: Thu, 19 Nov 2015 07:37:30 -0800 (PST)
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=5.148.145.14; posting-account=2W6y1goAAACIfK0LU9WhIh-uHZI0lyrI
NNTP-Posting-Host: 5.148.145.14
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <611b6103-4d5b-4e63-9a43-293cd0ad25b7@googlegroups.com>
Subject: Connecting to an SQL Server 14 database using ruby
From: cebirim@gmail.com
Injection-Date: Thu, 19 Nov 2015 15:37:30 +0000
Content-Type: text/plain; charset=ISO-8859-1
Xref: csiph.com comp.databases.ms-sqlserver:1947

Hi,

I'm trying to connect to an SQL Server database using ruby and am having difficulty running complex SQL statements.

I've been using the tinytds gem and can run simple SQL queries but not complex ones.

Can someone please help if they have been successful in running complex SQL commands against an SQL Server database in a ruby script?

Many thanks