passing SQL to SQL Server

Article View: borland.public.intrabuilder.data.sql

Article #11

Back to borland.public.intrabuilder.data.sql Previous Next

#11

From: Daniel Kosolofski
Date: Mon, 10 Nov 1997 00:00

34 lines
1550 bytes

Good Day all Guru's

I am hoping that someone will be able to help me.  I am trying to make
a query that has a semi-complex sum routine.  The sql statemwnt is as
followed...

SELECT dbo.pipeline.service_fluid, dbo.pipeline.nominal_diameter,
sum(dbo.pipeline.length), sum(dbo.pipeline.length * (DATEPART(year,
getdate()) - DATEPART(year, dbo.pipeline.commission_date))) FROM
dbo.pipeline GROUP BY dbo.pipeline.service_fluid,
dbo.pipeline.nominal_diameter

I know that what I am calculating makes no sense but that is the
calculation that the oil company wants.  Know my problem is that
Intrabuilder will not regonize the code until I turn requestLive to
false.  Once I do this it says that there is an error by '*'  I do not
understand this.  I use the same SQL statement directly in SQL Server
and it works perfect.

Please any help is appriciated and needed

Thanks

-- 
Daniel Kosolofski
Consultant
CGI Information Systems and Management Consultants Inc.
333 Seventh Avenue S.W.
Calgary, Alberta 
Canada T2P 2Z1
Voice: (403) 233-2713
Fax: (403) 262-8236
Email: daniel.kosolofski@cgi.ca

Technical Details

Message-ID: <34671e16.2733944@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 101d9a,47990f2ff9da6127,start
X-Google-Attributes: gid101d9a,public
From: daniel.kosolofski@cgi.ca (Daniel Kosolofski)
Subject: passing SQL to SQL Server
Date: 1997/11/10
Message-ID: <34671e16.2733944@forums.borland.com>
X-Deja-AN: 288312479
Organization: CGI Information Systems and Management Solutions Inc.
Newsgroups: borland.public.intrabuilder.data.sql