Recent content by nutrotek

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

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?

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?

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

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?

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

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.

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