here is is ...
'check to see if agent/dist code are already in temp table
sSql = "SELECT *" & _
" FROM TempSap " & _
" WHERE ProducerID='" & FixSQLString("" &
rs3!WritingAgentID) & "'" & _
" AND TaxID='" & FixSQLString("" & rs3!taxid)
& "'" & _
" AND DistributionCode='" &
FixSQLString(sDistributionCode) & "'"
Call SendToDwDb(sSql, rs5)
-----Original Message-----
From: Gerald Clark [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 14, 2002 11:11 AM
To: Mary Stickney
Cc: [EMAIL PROTECTED]
Subject: Re: null
That is really odd, because I don't see a select statement anywhere.
Mary Stickney wrote:
>SQL QUERY SQL QUERY
>
>
>I inserted a row , and set the sales to 0 for the years that there is none
,
>and set the sales to the sales amount for th years
>that there were some....
>
>
>INSERT INTO TempSap
>(taxid,Company,FirstYear,SecondYear,ThirdYear,ThruDate,WritingAgentID,Group
I
>D,
>NewCasePercent,RegionCode,FirstYearSales,SecondYearSales,ThirdyearSales,Per
c
>entOfCases,producerid,distributioncode,PremiumsInForce) VALUES
>(080323288,'PIC' , '2000','2001', '2002',
>'3/30/2002','0B917','N0305',1,'7B',0,0,18.59,50,'0B917','D4073',18.59)
>
>
>yet it brings back NULL in a select statment
>
>
>
>Mary Stickney
>TAG-TMI
>Data Warehouse / Imaging
>402-474-7612 x 3099
>[EMAIL PROTECTED]
>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
<[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
