Search results for query: *

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!

...FROM TMP UPDATE TMP2 SET CNT = DATECNT FROM ( SELECT id, COUNT(DATE) AS 'DATECNT' FROM TMP GROUP BY id)A WHERE A.ID = TMP2.ID SELECT * FROM TMP2 DROP TABLE TMP2 DROP TABLE TMP 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...

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!

Tom is right. I have used this several times and have been court out by the "keep together" option which at times can hide all the details....or was it groups.... either way it's good to be aware of it :D I feel sorry for people who don't drink, when they wake up in the morning that's as good...

Hey, This looks to be along the lines of what you need http://jamelcato.com/how-to-check-a-file%E2%80%99s-last-modified-date-using-ssis/. You could load the file names into a text file and use this a lookup document and it would work. The issue I see with this is that you have to maintain the...

If you are to put the this into crystal "select" is not needed (at least on the version I use) ( ( {Schedule.Activity} in ["1", "2", "3"] and {Schedule.Status} <> "X" ) or ( {Schedule.Activity} in ["4", "5", "6"] and {Schedule.Status} = "S" ) ) I am sure that the above would still return...

select {Schedule.Activity} in ["1", "2", "3"] and {Schedule.Status} <> "X" and select {Schedule.Activity} in ["4", "5", "6"] and {Schedule.Status} = "S" in the above you are asking for Activity that is 1,2or3 and status is not X. S is not X and may have activity values of 1,2or3 and will...

Only thing I can think of is to do a double (or 3rd) pass of the files. On the first pass get the modified date using a script task and add to the filename the date (also store the new filename else where for later reference) i.e. "myfile20110218" then once you have modified filename process the...