Search results for query: *

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!

awsome! it worked!!!, lil' more complex, but your description helped me figure it out. SELECT dbo.ConsignVbaseF.STY_ROYL, dbo.ConsignVbaseF.IVD_STYLE, dbo.ConsignVbaseF.IVD_COLOR, dbo.ConsignVbaseF.CUST_TYP, dbo.ConsignShi.SHIPQTY, dbo.ConsignShi.SHIPDOL...

i'll see if that works, and net does have all my records, i created return and shipped tables from net. thanks again! p.s. this is my first attempt @ sql and everyone @ tek-tips has been a great help!

:( no dice. if i just query "NETSHIP" in the NET Table, i get 1687 Records for a total QTY of 68160 in my joined table, i get 1500 records with a total QTY of 61008 anyone have this issue before? is it because some items may not have been returned so they dont show on the report?

i have three views for my data, one is quantity shipped, the other is quantity returned and the third is net i need to see the data like this: ITEM,ATTRIBUTE,QTYSHIP,QTYRETURNED,NETQTY but i cant seem to get accurate numbers out of them, i've just been joining everything to my net qty field...

i got about 600 users, so i should be OK until i'm not ;) thanks again