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

Thank You Borissov, that looks like it will work. I will not have time to test it today but i will keep you posted on my progress. Thank you so much!!!!

Here is some sample data: In The Database: Column Order: Vehicle ID, Equip ID, Date Added, Date Removed, Record Number 1 20 1/1/2007 1/25/2007 1 2 20 1/25/2007 NULL 2 1 25 5/16/2006 NULL 3 4 14 9/7/2005 5/20/2006...

DOes anyone have any ideas? Or is my post a little bit to confusing? Or Large?

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

Nevermind, I guess I would have to give supply a field to be in the sun-query. :& Thanks,

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

Thanks for the quick response Synapse, but it was just an error within Crystal Reports. I just logged off the server and logged back on and everything seems to work fine right now.

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

I think it may be best to just let this one go, I am going to investigate database views to fix this problem. Thanks for your help and i apologize for my communication.

What i would want to show in the transfer to/from field is the unit # of the vehicle that the equipment was last attached to. For example if the equipment(22) was moved from unit 3 to unit 1. for unit 3 it would show Unit # Equipment Transferred To/From 3 22...

I have found the problem, it was a join with the models_fw table. I had the left outer join from models to vehicles when it should have been vehicles to models. Thanks a ton for your help!

I do not have a group selection or section suprresion. but here is the sql query: SELECT DISTINCT "VEHICLES_FW"."VEHICLE_ID_FW", "ALLOCATION_REASONS_FW"."DESCRIPTION_FW", "DEPOTS_FW"."DEPOT_NAME_FW", "VEHICLES_FW"."BASE_LICENSED_STATE_FW", "USER_DEFINED1_FW"."DESCRIPTION_FW"...

The formula for {@UnitisBlank} is just {?Unit} = "" which checks to see if the user left the parameter blank. This field cannot be null as you are only able to select the blank record or an actual unit. The problem with this formula is it is not returning the correct amount of vehicles...

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

Here is just a shot of the sample data. The first column is vehicle id, the second column is equip ID, the third is date added and the fourth is date removed. 4 2 1999-12-01 00:00:00.000 NULL 6055 3 2003-03-01 00:00:00.000 NULL 6 4 1999-12-01 00:00:00.000 NULL 10 5 1992-03-01 00:00:00.000...

How would i go about obtaining the vehicle number if i were to go about the subreport approach? Is there a particular formula i would use? Thanks for your help!

What about using an SQL Expression? Is there a possible way to make that function in this scenario?

Or would it be smarter to create a view on the database and just use the view?