Search results for query: *

Hello all, I am comparing two dates in sql and it seems to be missing some records. the statement i am running is: select next_insp_date_Fw, last_insp_date_Fw, archive_status_Fw, insp_description_Fw, getdate() from user_defined19_fw where vehicle_id_fw = '1105' and next_insp_date_fw <=...

Hello All, I am trying to format a date to have no decimals. I am not sure if there is a function I can use. Select weightulw_fw --want to show with no decimals from vehicles Thanks y'all

Hello All, I am currently using SQL 2005. The select statement I am trying to make will pull in the equipment id, a string literal describing the transfer.(Addition, Deletion, Transfer To, Transfer From), and the unit number the vehicle was transferred from/to. This is the SQL i currently...

Hello All, I am currently creating a view and was wondering if it was possible to use an in statement within a case statement. Here is my current SQL: ************************************************************ select access_equip_Fw, case when (date_mounted_Equipment_removed_fw is null) and...

I have created a few reports within CR9 using SQL Server 2005 and after restoring the database to a more current version. I get this error for each table: The database table "Vehicles_fw" cannot be found. Proceed to remove this table from report?" After clicking no through all of the warning i...

Hello All, I am creating a report in CR9 with SQL 2005. The report is to display all vehicles that have had a status change within a time period. Here is the first part of my selection formula: The third line of the formula uses 2 isblank fields that check if the parameter has been left...

I am currently working on a report that needs to display mounted equipment transfers, additions, and deletions. This is my formula to check if it is a transfer: Stringvar MEChanger; if {user_defined20_fw.archive_status_fw} = 'A' then MEChanger := 'Deletion' else if...

Hello All, I am currently creating a view to select the equipment id, the count of how many times it is in the table, the vehicle it was attached to before Here is my sql: Select access_equip_fw as ME_ID, count(access_equip_fw)"count(access_equip_Fw)", (select top 1 vehicle_id_Fw from...

Hello All, I am running Crystal Reports 9 with SQL Server 2005. The problem i am having is trying to pull the last unit number that a piece of equipment was attached to. I am not sure where to even start with this process. select top 1 equipment.vehicle_Id from equipment where equipment_id...

I am using CR9(SQL 2005) and am having trouble making the inspections with null dates appear. Here is my selection code this far: IF ({@UnitIsBlank} and {@DivisionIsBlank}) and ({Command.NEXT_INSP_DATE_FW} <= {?ReportPeriodEnd} or isnull({Command.NEXT_INSP_DATE_FW}) or {@Due Date} =...

I want to filter the report by the change type associated. If the equipment is archived it is deleted, if the equipment is brand new it is added, if the equipment has been associated within the company before, it is transferred. Here is the formula i have: Stringvar MEChanger; if (not...

Hello All, I am writing a report that tells wether a piece of equipment has been transfered, deleted, or added. I am working with a history table so the only way i can check if the equipment has been transferred is to use an sql expression to count how many times the id shows up in the table...