Search results for query: *

How can I change a negative number result into a posotive number in Crystal Reports

It appears that both DATELEAVE and DATEOFLEAVING have some date and some varchar data. Is their a way I can convert them all to date format before I run the update?

I need the date as DD/MM/YYYY Although if I just use SET DATEOFLEAVING = DATELEAVE I still get the same error message

The datatype should be date format but I think some data has been entered as text. I do not know how to ensure the datatype is correct before running the update?

I have a simple update query: UPDATE SERVICES.dbo.MASTER SET DATEOFLEAVING = CONVERT(Char,b.DATELEAVE,103) FROM SERVICES.dbo.MASTER a JOIN SERVICES.dbo.EXITINTERVIEW b ON a.STAFFNO = b.STAFFNO When I run the query I receive the error message: Server: Msg 242, Level 16, State 3, Line 1 The...

I tried adding the code but the record does not update when I enter the leaving date?

I have a simple update query that runs as a job each evening.The query adds information from the Employee Master table to the Employee Leavers Table: UPDATE EMPLOYEE.dbo.LEAVERS SET JOB = JOBTITLE STARTDATE = CONVERT(Char,b.DATEOFJOIN,103) FROM EMPLOYEE.dbo.LEAVERS a JOIN EMPLOYEE.dbo.MASTER b...

I have a simple update query that runs as a job each evening.The query adds information from the Employee Master table to the Employee Leavers Table: UPDATE EMPLOYEE.dbo.LEAVERS SET JOB = JOBTITLE STARTDATE = CONVERT(Char,b.DATEOFJOIN,103) FROM EMPLOYEE.dbo.LEAVERS a JOIN EMPLOYEE.dbo.MASTER b...

My update query records the registration number, make and model of an employees company vehicle on his personnel record from a vehicle register where the switch CURRENT is ='T'(True) However, if the employee surrenders his vehicle for a car allowance I need to clear the vehicle details from the...

Thanks Y'all Works fine now

Putting in the space I still get the same error: Server: Msg 156, Level 15, State 1, Line 4 Incorrect syntax near the keyword 'CONVERT'.

I now get the error: Server: Msg 156, Level 15, State 1, Line 4 Incorrect syntax near the keyword 'CONVERT'.

...b.FUELCARDNUMBER IS NULL THEN 'N' ESLE 'Y')AS FUELCARD, ON a.REGISTRATION = b.REGISTRATIONNUMBER WHERE a.CURRENTCAR ='T' AND [DESCRIPTION] NOT LIKE 'Returned*' When I try to run it I get the error: Server: Msg 170, Level 15, State 1, Line 1 Line 1: Incorrect syntax near 'a'. Can you help...

Thanks works great

The reports are all the same format but addressed to different companies. The number of forms differ each day so I can not set up a rigid output command. I really need a way of allowing the users to print all the reports that are in a specific folder at the end of business each day and then...

Thanks Just one point. I do not know how many reports will be printed in any one day.

In my Access database users print reports to mail to suppliers about queries on invoices. I want them to be able to save these reports in a file and print them all together at the end of the day. I have created an output to file command button that saves the reports as a snapshot. Saving to...

This may seem a stupid question but I am very new to SQL. I have an update query that I want to run automatically each night at 11pm. Can anyone tell me how?

I have a SELECT query SELECT a.STAFFNO,a.REGION,a.DEPARTMENT, LEFT(REGION,3)AS REGCODE, LEFT (DEPARTMENT,4)AS DEPTCODE (DEPTCODE + REGCODE) AS ACCODE (DEPTCODE + REGCODE) AS COSTCNTRE FROM ELYOSERVICES.dbo MASTER a WHERE STATUS ='Active' Users enter REGION and DEPARTMENT from a pick list for...

Users enter a REGION and DEPARTMENT from a pick list in the SQL database for each employee. The format of these is: REGION: abc - Midlands - Birmingham def - London - Dagenham DEPARTMENT: 1234 - Engineer 5678 - Administrator I need to update the ACCODE & COSTCNTRE fields...