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

    average between datetime field

    thanks for the responses! SQL Scholar - I like the breakdown to seconds; this looks much better. simian336 - I want to be able to work out the Open Hours and mins between the 2 datetime fields for each record, which I can get but then work out the average open time for the whole dataset...
  2. le1234

    average between datetime field

    ...+ ':' + CAST(FLOOR((DATEDIFF(mi,[Open Date & Time],[Close Date & Time]) / 60 - FLOOR(DATEDIFF(mi,[Open Date & Time],[Close Date & Time]) / 60)) * 60) AS varchar(2)) AS castHourMin, CONVERT(varchar(10),DATEDIFF(mi,[Open Date & Time],[Close Date & Time])/60) + ':' +...
  3. le1234

    help with batch file

    no worries I found what I was looking for: -i Turns off interactive prompting during multiple file transfers. -s:filename Specifies a text file containing FTP commands; the commands will automatically run after FTP starts.
  4. le1234

    help with batch file

    great thanks for the help - this has worked for me. can i asked what are the -i and -s switches? thanks again for your help
  5. le1234

    help with batch file

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

    SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER

    Thanks for you help so far - I set the flag to Run64BitRunTime = False and I can now run the SSIS package successfully in VS and Management Studio however when I schedule as a job I still get the SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER error. any further ideas? I have...
  7. le1234

    SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER

    connection 1 is the connection to the access db (if I open that connection I can see the database I am wanting to import). all work carried out on the server server is 64bit Thanks
  8. le1234

    SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER

    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)...
  9. le1234

    datediff hh:mm:ss

    that was exactly what i needed. Many Thanks
  10. le1234

    datediff hh:mm:ss

    thanks ca8msm, i am trying to put this method into a query so that the difference will be calculated for the multiple rows returned. So i put the field name in the set statement instead of a specified date, but I get an error......can you recommend another way?
  11. le1234

    datediff hh:mm:ss

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

    text fields

    i did think that might be the case. i cant take the : out as that is creating the hours and minutes that i need. not to worry. thanks for your advice
  13. le1234

    text fields

    ...header) =trim(str(int(Sum(Fields!NumDuration.Value)))) + ":" + trim(str(int((Sum(Fields!NumDuration.Value) - int(Sum(Fields!NumDuration.Value))) * 60))) totaltimeteam is producing a total of time spent by all users, using the same calculation as above, is at the top of my report out of the...
  14. le1234

    text fields

    thanks for the suggestion. tried this but is still coming back as #Error, I also get the following output message: The value expression for the textbox ‘percentage’ contains an error: Input string was not in a correct format.
  15. le1234

    text fields

    ...and display values. i then want to be able to do a further calculation using the results from these two fields. =("totaltimeteam"/"totaltimeteam")*100 the report still runs but I get an error appear for this text field value. Am i doing something obviously wrong or is this something that...
  16. le1234

    sqlmaint.exe failed

    sqlserveragenterrorlog: [LOG] Unable to send job completion notification email to operator 'BOPSQL SQLBackup' for job 'DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan FULL BOPSQL'' maintenance log looks ok, no errors logged until the last line: End of maintenance plan 'DB...
  17. le1234

    sqlmaint.exe failed

    that is the message in the maintenance history.
  18. le1234

    sqlmaint.exe failed

    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?
  19. le1234

    sql profiler

    thanks again for your help, will do some further investigation
  20. le1234

    sql profiler

    thanks for the reply, the error I am wanting to trace is 'Invalid buffer from client, Error: 17805, Severity: 20, State: 3'.

Part and Inventory Search

Back
Top