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,GroupI
>D,
>NewCasePercent,RegionCode,FirstYearSales,SecondYearSales,ThirdyearSales,Perc
>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
>Mary.Stickney@stripped
>
>
>
>---------------------------------------------------------------------
>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 <mysql-thread117086@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
