Re: Hopefully easy question from a newbie

Article View: comp.databases.ms-sqlserver

Article #128

Back to comp.databases.ms-sqlserver Previous Next

#128

From: Bob Duffy
Date: Fri, 03 Dec 1999 00:00

9 lines
1065 bytes

Try this:

DTSDestination("costtotal") = val(DTSSource("cost1")) +
val(DTSSource("cost"))

or

DTSDestination("costtotal") = cdbl(DTSSource("cost1")) +
cdbl(DTSSource("cost"))

Technical Details

Message-ID: <UZM14.1545$as2.4716@news.iol.ie>

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

References: <7km1cc$3da$1@nntp.mica.net> <383bb707.9323253@news>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10f695,4e51240198d639f5
X-Google-Attributes: gid10f695,public
X-Google-Thread: ff490,4e51240198d639f5
X-Google-Attributes: gidff490,public
X-Google-Thread: 104de1,4e51240198d639f5
X-Google-Attributes: gid104de1,public
From: "Bob Duffy" <bob@prodata.ie>
Subject: Re: Hopefully easy question from a newbie
Date: 1999/12/03
Message-ID: <UZM14.1545$as2.4716@news.iol.ie>
X-Deja-AN: 556151137
References: <7km1cc$3da$1@nntp.mica.net> <383bb707.9323253@news>
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3612.1700
X-Complaints-To: abuse@iol.ie
X-Trace: news.iol.ie 944217076 194.125.122.200 (Fri, 03 Dec 1999 10:31:16 GMT)
Organization: Ireland On-Line Customer
NNTP-Posting-Date: Fri, 03 Dec 1999 10:31:16 GMT
Newsgroups: comp.databases.ms-sqlserver,cz.comp.microsoft.sql,microsoft.public.sqlserver.server

Reply to Parent Message