OLEDB SOURCE QUERY THROUGH EXPRESSION

• h.singh10

  Right there with Babe

  Points: 731

  More actions

  January 10, 2012 at 11:10 am

  #254715

  Hi

  I am putting the below query in a OLEDB SOURCE through a variable (it is a select statement with a where clause from one date to another).

  I am getting through this expression. Can you have a check on it please.I dont know whats is wrong with this expression

  "select TestRecordtype, request_id from department

  where LOAD_TMSTP between

  (select max(END_TMSTP) LOG) and

  (TO_DATE("+RIGHT("0" + (DT_STR,4,1252)DATEPART( "dd" , @[System::StartTime] ), 2) + "-"

  +RIGHT("0" + (DT_STR,4,1252)DATEPART( "mm" , @[System::StartTime] ), 2) + "-"

  +RIGHT("0" + (DT_STR,4,1252)DATEPART( "yy" , @[System::StartTime] ), 2) + " "

  +RIGHT("0" + (DT_STR,4,1252)DATEPART( "hh" , @[System::StartTime] ), 2) + "."

  +RIGHT("0" + (DT_STR,4,1252)DATEPART( "mi" , @[System::StartTime] ), 2) + "."

  +RIGHT("0" + (DT_STR,4,1252)DATEPART( "ss" , @[System::StartTime] ), 2) +",'DD-MM-YY HH24.MI.SS')) "

  Thanks

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  January 11, 2012 at 8:21 am

  #1431830

  I think the problem is in this line:

  (select max(END_TMSTP) LOG)

  There is no FROM clause, is LOG an alias for MAX(END_TMSTMP) or is the query supposed to be:

  Select MAX(END_TMSTP) FROM LOG

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question