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 Chris Miller 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. nutrotek

    File Attachment Name in Body of Outlook Email

    How do I get an attached file name in the body of an Outlook email? When I sent an email out with an attachment, the recipient replies they completed the job, but it doesn’t include the attachment. The attachment names have a long ID. If I could somehow receive the attachment name only back in...
  2. nutrotek

    Implicit Conversion Problem with Money

    Trying to run the following query using field Cost(Money): CASE WHEN Cost IS NULL THEN 'N/A' ELSE CONVERT (MONEY, Cost , 1) END I get an implicit conversion. How do I fix?
  3. nutrotek

    Special Date/Interger Question

    Hello, I know how to take these two fields: DateValue, 01/01/2007 and IntValue, 10 and create one field: 010107-10 REPLACE(CONVERT (VARCHAR(8), DateValue, 1), '/', '') + N'-' + CAST(IntValue AS VARCHAR(3)) How to I reverse the process, turn 010107-10 into 01/01/2007 and 10?
  4. nutrotek

    varchar & decimal in same field

    Hello, I have data results in a SQL database. The results can either be <1 or a numeric decimal value such as 1.2 or 20.75. The <1 are stores in the field TextValue and the actual results are stored in the field LabValue. I download these results to Excel for calculations. My clients want...
  5. nutrotek

    Add a character in 7th position in string.

    Hello, I have a string field 071106100. How do I add a "-" in the 7th position of the string so it looks like 071106-100?
  6. nutrotek

    Round Down to Lowest 100

    How do you round down to lowest 100 in SQL? Example 799, should be 700; 11069 should be 11000. Thanks.
  7. nutrotek

    Round Number to Highest 0.25

    How do you round a decimal value in SQL to the highest 0.25? I'm trying to use the CEILING() function from Excel. In Excel the function CEILING(13.05,0.25)=13.25. In SQL SELECT CEILING(13.05)=14. In SQL, ceiling only has one arguement. I'm using SQL2000, if that matters. Thanks for your help.
  8. nutrotek

    Case Statment with GETDATE()

    I'm trying to write a CASE statement that evaluates if GETDATE() > Todays Date at 12pm. If true I want to use tomorrows date at 12pm, if false use todays date at 5 pm. This is what I came up with: CASE WHEN (CAST(GETDATE() AS DECIMAL (24,2))) > (CAST(GETDATE() AS DECIMAL (24,0)) + .5) THEN...

Part and Inventory Search

Back
Top