Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. civilwarjunky

    Hang up on Login

    I am running Citrix what looks to be 1.3 that is what shows up in the about in the management consol. When users go to login they put in thier user name password. The Dark blue screen that appears while waiting for desktop appears. You see the start button task bar on bottom flah by really...
  2. civilwarjunky

    Needing Help with a sub query

    I am new to SQL and I need to preform a sub query I think t0 get info I need. The code I am sending is returning all customers that have ever ordered BHM since 4-22-2005. I have verified it and the return is correct. I know need to go one step ruther and I need to now all customers that have...
  3. civilwarjunky

    I have two computer with same name

    I had 2 computers with the same name.( DCC74 ) I changed one of them and but the second one still cannot get on the network. The one I changed has access now. DNS shows DCC74 is logged with and IP address, I can ping the computer but the user cannot log into the domain controller. Can you help.
  4. civilwarjunky

    Network Restarting

    We are a small company running a windows shop with 7 servers. We are not a 24/7 shop. Each morning we restart our server to clear the cash and memeory buffers before the general staff comes into work. We are in the middle of add an other server to our system. What are the downsides to...
  5. civilwarjunky

    Adding wireless router to my network with cable modem

    I am new to networking. I have a small nework at home running off of a dell power edge 2450 server. I have it configure as a DNS Server, DHCp, and IIS, I primarly use it for Database developement. I recently picked up a wireless router, contected it to my cable modem and connected that to my...
  6. civilwarjunky

    Windows Licensing question

    I and new to multi server inviroment and we are adding 2 new server to our network which will give use a total of 8 servers. My under standing is that we will only need 8 standard edition , client Access Licenses. Each of our work stations have there own licenses and we have 50 workstations...
  7. civilwarjunky

    ASP.Net Timeout in SQL

    <%@ Register TagPrefix="CRM" TagName="Header" Src="Controls/SiteHeader.ascx" %> <%@ Page Language="vb" AutoEventWireup="false" Codebehind="CustomerSummary.aspx.vb" Inherits="CRM.CustomerSummary" %> <HTML> <HEAD> <title>DCC CRM Application</title> <link href="Styles.css" type="text/css"...
  8. civilwarjunky

    ASP.Net Timeout in SQL

    I am new to .net and SQl working together where would I kind the the Sqlcommnad.timeout =120. Would it be in the SQL script itself or the .net page.
  9. civilwarjunky

    ASP.Net Timeout in SQL

    I am need to ASP.net and I would like to know how to change the timeout string in the follow application. Server Error in '/OrderEntry' Application. -------------------------------------------------------------------------------- Timeout expired. The timeout period elapsed prior to...
  10. civilwarjunky

    Restoring Development DB from Production

    I have created a development database called CustomerRelationsDev and I want to restore a copy of my production database to it, and it is called CustomerRelations. I made a backup of CustomerRelations. How do I get CustomerRelationsDev to Restore from my production backup. I have tried changing...
  11. civilwarjunky

    Using a Coalesce function

    H01 H14 1.0 H01 H104 1.0 H01 H174 1.0 H01 S15 1.0 H01...
  12. civilwarjunky

    Using a Coalesce function

    I am working on an inventory project, and I am new to SQL. I have completed 2 querries, one pulls available inventory and the second one pull kits, and the items required to build them. I am trying to come up with an inventory check querry, so that when a kit id such as H01 called it will check...
  13. civilwarjunky

    Grouping

    I would like it to look like this name program Item qty Alex,Abbassi MD Pregnancy Pregnancy Spanish 600
  14. civilwarjunky

    Grouping

    I have writen my querry and it runs fine. I am new to sql and have not have much experiance in grouping. Iwould like my querry have the persons name show only once, and when mulitipal programs show up I would like that to show up once with a total number of that program. Same is true with the...
  15. civilwarjunky

    Troubloe Grouping

    it is not grouping correctly or suming
  16. civilwarjunky

    Troubloe Grouping

    I am trying to group them by item# and total each item number. Example D19 = 1200 and do this for each item. select soline.Invtid as 'Item #',soline.descr as 'Description', soline.qtyord as 'QTY',soline.status, sum(soline.qtyord) from soline where status='o' Group by soline.Invtid...
  17. civilwarjunky

    Need Help with Grouping

    I am somewhat new to SQL and need help grouping my qurrey. select Trandate as 'Order Date', artran.invtid as 'item #',inventory.descr as 'discription',artran.qty as 'Qty' from artran,Inventory,Customer,Salesperson,custclass where artran.invtid=Inventory.invtid and...
  18. civilwarjunky

    Need Help Grouping By

    I am somewhat new to SQL and I am have a little trouble grouging items. My querry gives me the correct resualts other than I am not so fluent with grougping. Below is my code, and I need to group by item # ,and then total quantity of each item. Can you help ? Thanks select customer.custid as...
  19. civilwarjunky

    New To SQL Need Help creating Update

    Hi - I am new to sql and I am in the need of an update. I am looking to update my locations table using the following critera. I want to up date all records that have a countyid of 208 and have the following names. Update Location set districtid=285 where countyid=209 and location.name=Napa...

Part and Inventory Search

Back
Top