List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:August 14 2002 4:10pm
Subject:Re: null
View as plain text  
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
>
>


Thread
nullMary Stickney14 Aug
  • Re: nullGerald Clark14 Aug
    • RE: nullMary Stickney14 Aug
      • Re: RE: nullVictoria Reznichenko15 Aug
        • RE: RE: nullMary Stickney15 Aug