Search results for query: *

currently trying to extract the time difference bewteen two date time fields and then work out the average on the results. I can pull out the hours and mins between the two datetime fields using convert however if I try and run an average I get an error as its not a number value field. can...

i would like to create a batch file that connects to an ftp area and picks up a txt file and places in a directory specifed on the C drive....anyone help with the code required... I have made a start but all it does is load ftp via cmd prompt. Any help would be really appreciated - I need to...

I have a DTS package that has been migrated to SSIS (basically it pulls data from a table in and access db and dumps into a sql db table) - I have updated the connections as required and tested that they work correctly (I can preview the data within the access table that I want to copy over)...

i need to be able to calculate the difference between to dates and show the results as hh:mm:ss

not sure if this is at all possible but i have two text fields 'totaltimeuser' and 'totaltimeteam' on my report that do various calculations and display values. i then want to be able to do a further calculation using the results from these two fields. =("totaltimeteam"/"totaltimeteam")*100...

currently have an optimization job with 1 step which keeps failing. When I view the job history all i get is the following error message: sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed. Is anyone able to help?

new to using the sql profiler, i would like to be able to have the profiler running to trace/record when an error appears in the server logs, i also would like the results to be saved in a table. any advice / tips on how to set this up would be very helpful. i have previously tried but seem to...

can anyone help? using a stored procedure as dataset. i am only getting 1 line of results back in the preview tab when I am expecting 3 lines as I get in the data tab..

quite new to reporting services. i am using a sp as my dataset. the report works fine and as expected when i run within the data tab. when i click on to the layout tab i dont have any fields to put on my report, tried adding a txt box with the following in =Fields!fieldname.Value however when i...

help! I have a current field that is stored as a varchar(500), users enter dates into this field. I need to convert the field to an english date but I am having problems, any ideas would be greatly appreciated.... values when selected in query analyser are shown as 2006/07/02 15:20:00 if I...

any chance anyone can help with the following query. I am having trouble with the where statement. I have a field CrewReported which is a free text string field that users enter a date into. i need to use this field as a date in my where criteria. when i do i get an error saying 'Invalid Column...

Can anyone help with the diference I am getting when running these two queries. I have a duration field that is stored in miliseconds which I am trying to convert - but the deurations come out different if I use CONVERT or CAST. SELECT dbo.actuals.TaskId, dbo.actuals.Who...