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!

Search results for query: *

  1. 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...
  2. 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
  3. 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...

Part and Inventory Search

Back
Top