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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by SpaceMonkey4969

  1. SpaceMonkey4969

    Select Non-Duplicate rows

    Opps sorry, should of gave more information. the main table of data has hundreds of rows. So i need some sort of insert/select that can identify when there is Multiple descriptions, and when there is, only insert the 1st record into tblSep1, and insert all the different Quantity's into tblSep2...
  2. SpaceMonkey4969

    Select Non-Duplicate rows

    Hello Ok here's my question, I sure hope you guys can help me. I'm writting a query to Select the data from 1 table (TblData) and Insert it into 2 separate tables (tblSep1 & tblSep2). The 1st table that I'm going to insert into contains the Main types of Units, The second table will...
  3. SpaceMonkey4969

    Checking for Numeric Data

    ok, I Guess i Should give more information the data can range from anything such as 4g or 4 g.. to something like 100mg/ml
  4. SpaceMonkey4969

    Checking for Numeric Data

    Hello, My problem is: I have a nvarchar field that contains numerics and characters. an example would be 30mg. I need some sort of routine or function i can use to store the 30 in a variable that is of type Numeric. Thx in advnace
  5. SpaceMonkey4969

    Duplicate question

    Well, the thing is the main things i'm trying to display is, when a USER logs in from outside our network, I want to be able to display the IP they logged in from, and the all the other information in the USERS table, which is: strUserName, strIPAddress, intUserID, datDateTime, strGroupName...
  6. SpaceMonkey4969

    Duplicate question

    Hello My question is: I have 1 table, it is a table for USERS. In this table I store information about the user such as IP ADDRESS, Name, ID, time and Date. I need to create a query that will Select the users Name, Ip, date and time etc, for a distinct IP. AKA a user can log in from many...
See more

Part and Inventory Search

Back
Top