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

    Email Not Sending When Adding File Names to Body of Email

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

    Deriving a Column that Calculates Date Difference in Minutes

    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!
  3. NiceArms

    Blank a field if contains a date

    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!
  4. NiceArms

    selective rollups?

    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!
  5. NiceArms

    selective rollups?

    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'...
  6. NiceArms

    2 Date Range Queries 2 Differing Results

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

    2 Date Range Queries 2 Differing Results

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

    2 Date Range Queries 2 Differing Results

    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!
  9. NiceArms

    2 Date Range Queries 2 Differing Results

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

    Strange Date Conversion

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

    OUTPUT/UPDATE - log data from the updated table

    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!
  12. NiceArms

    OUTPUT/UPDATE - log data from the updated table

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

    getting data from a parameter

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

    report

    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!
  15. NiceArms

    Formula Help for selecting different data rom two fields

    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!
  16. NiceArms

    supress detail section

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

    Looping through files sorted by date

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

    Formula Help for selecting different data rom two fields

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

    Formula Help for selecting different data rom two fields

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

    Looping through files sorted by date

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

Part and Inventory Search

Back
Top