Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    84

    Unanswered: chr(10) in an insert statement.

    Can someone help me parse this oracle insert statement into SQL Server please?

    insert into notify_template (subject, body, priority)
    values
    (
    '
    Budgeted time exceeded for task [18040]
    ',
    '
    Actual Time exceeds Budgeted time for the following task'
    || chr(10) || chr(10) ||
    ' Task Name : [18040]
    Root Program Name : [18049]
    Actual Days : [2000000100]
    Budgeted Days : [2000000101]
    Estimated Time : [2000000102]'
    || chr(10) || chr(10) ||
    ' The following resource(s) in the above task have exceeded the budgeted time:'
    || chr(10) || chr(10) ||
    ' [2000000784]'
    || chr(10) || chr(10) ||
    ' Click here : [12865]
    ',
    2)
    Kishore

  2. #2
    Join Date
    Mar 2004
    Posts
    84
    Got it...


    + CAST(CHAR(10) AS VARCHAR) + CAST(CHAR(10) AS VARCHAR) +
    for || chr(10) || chr(10) ||
    Kishore

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •