Recent content by soutener

sorry if its wrong forum... i'm looking for software to easily build online catalogs (we want to stop printing them) where all we need to do is have some software that generates the code, and we just have a insert pictures and descriptions, and it builds it for us and preferably comes with a...

who do i ask to create a retail pro forum? www.islandpacific.com i use it and i know of many others that do as well.

ah, that makes perfect sense thanks

the nub returns... i've tried several ways, and even google, but i'm yet to find an answer... i have two tables, A and B i want to update table A on column a.2 to equal b.2 where a.1=b.1 how i ask can i do this, here is what i tried: UPDATE NOFEAR.dbo.ConsignIVHSTH SET...

LOL!!!!!! i'm such a nub thanks

thanks bborissov! nub error i guess..... one more question regarding this.. how can i use that to update a column? i tried : UPDATE NOFEAR.dbo.ConsignTblMaster SET VendorCut CASE WHEN AVGPERCSALE < 0.95 THEN (((0.95-AVGPERCSALE)*Factor)+VendorPerc) ELSE...

ColG is VendorPerc Msg 195, Level 15, State 10, Line 1 'VendorPerc' is not a recognized built-in function name. this error is displayed when i try it, any idea why? SELECT AVGPERCSALE, Factor, VendorPerc ( CASE WHEN AVGPERCSALE < 0.95 THEN (((0.95-AVGPERCSALE)*Factor)+VendorPerc)...

brilliant! thanks

Divide by zero error encountered." i get above error when i try this code... UPDATE SET AVGSL=NETDOL/NETQTY my data types are decimal i'm trying to figure out the average selling price thanks

LOL, OK, im going to start a new thread, i've asked enough on this one, thanks everyone for your help!

where can i get a how to on how to build reports using reporting services for 2k5?

Divide by zero error encountered." i get above error when i try this code... UPDATE SET AVGSL=NETDOL/NETQTY

=IF(E4<0.95,(((0.95-E4)*H4)+G4),G4) i'm working on a report that is semi done in excel, i want to make the report available in an ASP web page and i dont know how to make the forumula above work in SQL is it possible? will i be forced to use t-sql (never used before) thanks!

LOL! one more UPDATE NOFEAR.dbo.ConsignTblMaster SET RETDOL='0' WHERE RETDOL=NULL; that doesnt replace my nulls w/ zero's, what am i do'n wrong?

oh, and my next question is, how can i calculate qty sold against $ sold to get an average selling price? thanks again!