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 TouchToneTommy 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: *

  • Users: StateGov
  • Content: Threads
  • Order by date
  1. StateGov

    Count Number of Records

    I am using SQL 2005 and I would like to count the number of projects (records) between two dates keeping the current date (getdate) in mind. I am trying to find out how many projects exist between these two dates. I have searched the forum and I cannot find anything pertaining to it. Thanks for...
  2. StateGov

    Concatenating Row Values into 1 Record/String with Commas Suppressed

    Hi Everyone, I have the following in a view that I created in SQL 2005: RTRIM(County_Code_1 +', ' + County_Code_2 +', ' + County_Code_3+', ' + County_Code_4 +', ' + County_Code_5) As County, While it serves the purpose of joining all of the fields into one single string, it does not suppress...
  3. StateGov

    Querie Joins

    I have 3 tables. The first table is the one side that contains project specific information with a primary key (Indexed, No Dups). The second table has the same primary key as a foreign key, however, it contains duplicate information (duplicate primary keys) so it is a many table that contains...
  4. StateGov

    Query - Obtaining Specific Dates

    Can anyone tell me how I would add information to a query that would allow me obtain the LastUpdate to a particular field. I.E. I have a database where a user updates particular estimates, however, all estimates are retained in this dbase...I would like to pull out the last date for a particular...

Part and Inventory Search

Back
Top