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 derfloh 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. StateGov

    Count Number of Records

    The last month (30 days). Thank you.
  2. StateGov

    Count Number of Records

    Thanks for responding so quickly, however, is there a way to automatically calculate the number of projects for a specific timeframe without actually entering dates....like a month at a glance? Thanks.
  3. 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...
  4. StateGov

    Concatenating Row Values into 1 Record/String with Commas Suppressed

    That worked with a little tiny tweak: County = case when Cty1 IS NULL or len(ltrim(Cty1)) = 0 then '' else ltrim(rtrim(Cty1)) + ', ' end + case when dbo.Cty2 IS NULL or len(ltrim(.Cty2)) = 0 then '' else ltrim(rtrim(Cty2)) + ', ' end + case when Cty3 IS NULL or len(ltrim(Cty3)) = 0 then ''...
  5. StateGov

    Concatenating Row Values into 1 Record/String with Commas Suppressed

    Hello, I am still new to this so I apologize for my ignorance. Null would be if it actually had the word "Null" in the field? Blank is if nothing showed in the field at all? They are blank if the above scenario is true. Does this help? Thank you.
  6. StateGov

    Concatenating Row Values into 1 Record/String with Commas Suppressed

    Hello, It still does not suppress the commas: PAS, , , , , When there are null values for the five additional county fields, it still adds the commas. I used exactly as follows: rtrim(COALESCE(County_Code_1+',','') + COALESCE(County_Code_2+',','') + COALESCE(County_Code_3+',','') +...
  7. StateGov

    Concatenating Row Values into 1 Record/String with Commas Suppressed

    It still leaves a comma after populating with the data (ie. BUR, MID, MON, - Any other suggestions? Thanks.
  8. StateGov

    Concatenating Row Values into 1 Record/String with Commas Suppressed

    Thank you.
  9. 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...
  10. StateGov

    Querie Joins

    PS. I forgot to mention that I would also like to know which table the DeptID and Dept_name would be extracted from since it does exist in tblAppr as well as the newly created table(not listed above). Thank you.
  11. StateGov

    Querie Joins

    No, I still have not been successful. I am pasting my query below, maybe this will provide some insight into exactly what I am trying to accomplish: SELECT tblProjs.ProjID, tblProjs.Perc, tblAppr.DeptID, tblAppr.Dept_name, tblAppr.Budgeted_hours, tblActuals.Spent_Hours FROM (tblProjs INNER JOIN...
  12. StateGov

    Querie Joins

    I wrote this in a hurry. I am very capable of writing correct english, however, when I attempt to explain a problem I am encountering, it doesn't always come up the way I want. Excuse me for attempting to get help.
  13. 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...
  14. StateGov

    FILL BLANK FIELDS WITH "0"

    Write an Update Query to update the field to "0" when null.
  15. StateGov

    Create Access DB from SQL Server table

    Just make sure the table is shared with the proper permissions. Whoever links to the table must have select, insert, update, etc. rights in order to write back to the SQL table.
  16. StateGov

    Query - Obtaining Specific Dates

    The data that appears in the field appears as below: 4/2/2001 11:16:04 AM The query statement is as follows: Last Update: DMax("[Last_Update]","dbo_tbl_Project_Estimate") or Last Update: DMin("[Last_Update]","dbo_tbl_Project_Estimate") When using...
  17. 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