Recent content by ryan010101

I turned on Kerberos logging and I'm now getting the below error. I've looked through the white paper but I'm not exactly sure how to fix this. So far today my email problem has not happened. I wonder if they are actually related. Event Type: Error Event Source: Kerberos Event Category...

We have an Exchange 2000 server running. I recently set up a Win2003 box with Exchange 2003, the goal to move everything from the old Exchange server to the new one. I have the new Exchange server running and everything seemed to work. I created a test mailbox on the new server and was able...

PSC, I currently have a SBS 2000 setup and I'm attempting to install a Win2k3 server and Exchange 2003 on a new server (actually Win2k3 is already installed and running). I'm assuming, even though I'm using SBS, I need to still do the "adprep /forestprep" and "adprep /domainprep" on the W2k box...

Our Exchange Server is part of Small Business Server 2000. This server is getting bogged down so we want to get another server and install Exchange 2003 on it and stop using the Exchange part of SBS on our old server. Is there any limitation of SBS that would prevent this? I searched but...

GingerR, I'm not sure what your point is. Should I not ask a question because I previously asked a similiar question months ago (and never received a response)?

Anybody else what to take a stab at this?? thanks Ryan

Thanks but I didn't mention this before but I need it to display items that are on programs even if the customer hasn't made any purchases yet. Add that to the where clause and it only returns items on the program that the specified account has purchased. I need it to display all items on the...

Thanks for the response. Isn't that just going to make it so customer_num is included in the results? I need to be able to specify a customer_num and have only their sales summed in Sum(e.qty_ordered). thanks

I need to modify this query again. Currently I'm summing the "qty_ordered" from the table "excsales". Another field in the table "excsales" is customer_num. I am going to provide a customer number and I want to only sum the qty_ordered for that particular customer. Can that criteria also be...

Thanks for the help! -Ryan

catalog" looks like this: sku product (this is the product name) upc There are other fields but these are the only ones I need. For more bg on what I'm doing, this is being used on a web page. There are "programs" and SKUs are assigned to programs. These SKUs that are on programs are stored...

Three tables: items_on_programs, execsales, catalog Below is the current query I have which uses items_on_programs and execsales. The results displays a list of SKUs and shows how manu were ordered (SUM(e.qty_orderd). I need to not just display the SKU, but also the product name and UPC for...

The problem was the ORDER BY part. Must not be able to use SUM in that part. This works for me: SELECT itm_ord_num, Sum( qty ) AS Qty1, oper_id3, vfy_date FROM carton_contents WHERE vfy_date >= '2004-12-06' AND vfy_date <= '2004-12-06' GROUP BY itm_ord_num, oper_id3, vfy_date ORDER BY Qty1...

If I take out the ORDER BY part, it works. thanks

Thanks but I'm still getting "Invalid use of group function". ??