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...
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...
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
=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!
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 have an intranet web page that i put reports on to using sql server/asp i have a database of peoples names, titles and thier phone extensions, this data has to be updated separately from Active Directory, i know there is some thing called ADSI wich i can use to query the database and...
I know where to configure it in AD users & computers, but what i dont know is how to write the script in vb
i want to add printers and map drives everytime a user logs in to any computer within the domain, i currently have a good ol' batc file, but it doesnt work half the time
can some one hook...
http://www.msexchange.org/tutorials/Remove-Exchange-server-entire-Exchange-organization.html
it was hard looking this up, my goal was to decomission an exchange server to move all the services on the new server.... everywhere i looked, nothing, maybe my terminoligy, but hopefully this helps...
I just installed ISA 2004 and i want a GPO to force all users within specific OU's to get it configured for thier proxy and i want the GPO to block them from being able to change the Proxy server settings (this part i know)
what i dont know is how to force the proxy server settings on all the...
here's the story:
have a providex database that i suck data out of and into a sql server (using ssis and odbc) to create reports, the invoice detail table there are a couple of types of invoices, in short some return to stock and credit the customer where and some send out stock and bill the...
I am trying to create a view in microsoft sql server 2005, where it pulls in invoice details for last month, i can use the between command and get it working just fine, but i have to change it every month, the view is used for a report that runs on an asp web page
my question is simply how do i...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.