Recent content by NiceArms

Hello, I am having an issue with adding file names to the body of an email, when I add the file names which are passed to the body via a variable the email will not send (no error appears), however if I pass some text to the body the email sends. Does anyone has any thoughts? 'on error resume...

This will give you the difference between the createddate and releasetime in minutes (assuming that both fields are datetimes?) DATEDIFF(MI,PCR.CreateDate,PCR.POReleaseTime) I feel sorry for people who don't drink, when they wake up in the morning that's as good as the're going to feel all day!

do you mean, SELECT CASE WHEN RM_JOB.ACTUAL_COMPLETION_DATE = '01/01/1999' THEN NULL ELSE RM_JOB.ACTUAL_COMPLETION_DATE END FROM ATable I feel sorry for people who don't drink, when they wake up in the morning that's as good as the're going to feel all day!

Gah i missed you last post!!!! http://msdn.microsoft.com/en-us/library/ms177410.aspx - PIVOT looks to be what you need :D I feel sorry for people who don't drink, when they wake up in the morning that's as good as the're going to feel all day!

Hey, If I have understood you correctly I think this is what you are looking for: CREATE TABLE TMP ( id VARCHAR(100), REF VARCHAR(100), DATE DATETIME) CREATE TABLE TMP2 ( id VARCHAR(100), REF VARCHAR(100), DATE DATETIME, CNT INT) INSERT TMP VALUES('PAFGLLE105000P0DMDEN', '2140628'...

It makes 100% sense, thank you. I feel sorry for people who don't drink, when they wake up in the morning that's as good as the're going to feel all day!

I have used the following many times (on other databases) without issue: WHERE CONVERT(varchar(10), TransactionDate, 103) >= '30/09/2011' AND CONVERT(varchar(10), TransactionDate, 103) <= '03/10/2011' I feel sorry for people who don't drink, when they wake up in the morning that's as good as...

datetime and British I feel sorry for people who don't drink, when they wake up in the morning that's as good as the're going to feel all day!

Hey Everyone, This one has me quite confused. I have 2 snippets of code which I would expect to return the same results but they are not. Snippet 1 returns the full range of transaction dates but snippet 2 returns nothing, not a single result. --Snippet 1 SELECT TransactionDate...

Hey, I am pulling a date from the database which has a data type of varchar(50) and with the use of flat connection file manager I am exporting the data into a .csv. the data in the varchar(50) is a date presented as dd/mm/yyyy but the date is converting to yyyy-mm-dd 00:00:000 when exported. I...

I have found another way of doing it but I will still try this. The original query was going to become dynamic. Thank you, nice I feel sorry for people who don't drink, when they wake up in the morning that's as good as the're going to feel all day!

Hi, the follwing code is trying to insert into table1 the deleted data and some static data following an update of table2. I am trying to get the field AccountID from table1 to update into table2 but i keep receiving the following... The multi-part identifier "table1.AccountID" could not be...

I may have the fields the wrong way round but when using IF logic I tend to write it as follows: if {?Severity} = "none" then {IRSCLAIM.COVERAGE}= "FALL" and {IRSCLAIM.SPECIAL20} = "05" ELSE if {?Severity} = "Minor" then {IRSCLAIM.COVERAGE}= "FALL" and {IRSCLAIM.SPECIAL20} = "10" else...

This may help, or at least get you started. http://msdn.microsoft.com/en-us/library/cc280478.aspx I feel sorry for people who don't drink, when they wake up in the morning that's as good as the're going to feel all day!

LBass is right - it's the OR that you need. For some reason unknown to me I was thinking of the 2 lines as 2 different formulas!!!!!! Try LBass's code. I feel sorry for people who don't drink, when they wake up in the morning that's as good as the're going to feel all day!