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

    Getting 1 answer from 2 other fields.

    That worked like a charm :) Thank you so much. How do I commit the change to the field and is there a way of getting just the date (rather than having 01/01/2015 00:00:00). Many thanks Scott
  2. diskmonitor

    Getting 1 answer from 2 other fields.

    Thank you for your help everyone. Would this be the correct code ? : SELECT [Purchase Date] [Warranty Time] DateAdd (year, [Warranty Time], [Purchase Date]) AS [Warranty Expiry] FROM ITInventory It keeps saying 'Incorrect syntax near 'DateAdd' Would it matter if some of the...
  3. diskmonitor

    Getting 1 answer from 2 other fields.

    Thank you for the code but it seems to fail on 'DateAdd' - it says 'Incorrect syntax' Thanks Scott
  4. diskmonitor

    Getting 1 answer from 2 other fields.

    Hi, I'm very new to SQL so I'm hoping that someone can help me with some step-by-step tips. I've got a database table called 'ITinventory' which has three fields : - Warranty Time (this would have 1,2 or 3 which would correspond with 1year, 2years or 3 years). - Warranty Expiry -...
  5. diskmonitor

    Mediapool

    Hi, I've had Brightstor 12.5 for a few weeks and think I may have started the mediapool off with wrong settings. My question is.....Can I start a new media pool, let it create all the necessary DLY, WKL, MLY sets and then simply move media over to the new pool ? Many thanks Scott
  6. diskmonitor

    SQL Server 2005, Huge LDF file.

    Hi, I have a database running on SQL Server 2005. The database is 20Gb and the LDF file is 35Gb ! I'm now running low on disk space and want to shrink the log file. How can I do this and how can I stop this happening again ? Many thanks Scott

Part and Inventory Search

Back
Top