Folks,
Have two tables:
TblHier Hierarchy Table
Fields Level0, Level1, Level2, Level3, Level4 (all int)
TblProduct Product Listings
Fields ProductNumber, Level0, Level1, Level2, Level3, Level4 (all int)
I am using the following query to count how many products have the correct hierarchy...
Folks,
I was looking for at a troubling program in Task Manager, when all of a sudden it changed look. It is now no longer showing the menu bar. Have a look at
http://www.geocities.com/amacfarl/taskmanager.jpg
I think I was dragging and dropping at the time. On the other users on my pc it is...
Hi Folks,
I am looking for a hosting package, and I was wondering if anyone can suggest one. I have a 4GB SQL Server Database, which is queried using JSP. Performance is key as I am using full text indexing.
Any suggestions?
Regards
Angus
Hi Folks,
I have the following HTML form:
<FORM action=http://..../......dll method=post>
<INPUT type=checkbox CHECKED value=ON name=sendcopy>
<INPUT maxLength=100 size=60 value="Question" name=subject>
<TEXTAREA name=message rows=7 wrap=VIRTUAL cols=58></TEXTAREA>
<INPUT...
Hi,
Once again SQL is driving me up the wall ;-)
Scenario: Two tables,
T_Sellers - Listing all the seller information
T_Sales - Listing all sales by product.
I am wanting to update a field in T_Sellers which is the total number of sales for that seller (NumOfSales). I have written...
Folks,
I have the following table in MS Access:
TABLE: ProductsForSales
Seller
Category
IsSold
QUESTION 1: I know that you cannot use COUNT(DISTINCT xx) in MS Access. However how can I run a query returning the number of Categories the Seller is currently Selling in...
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.