Results 1 to 3 of 3

Thread: Tough Question

  1. #1
    Join Date
    Apr 2008
    Posts
    2

    Unanswered: Tough Question

    Ok, I'm needing to write a view for a 3rd party scripting tool to call. Apparently this scrpting tool cannot call a function or SP.

    Here is the problem. The view needs to take a notes col and a date col
    and concat them together as one col and the cus acct # as 2nd col.
    There will be several rows of notes to one cus acct #.

    So if a normal select against this returns

    note date acct
    ================================
    txt1 1/1/00 1
    txt2 1/2/00 2
    txt3 1/3/00 1

    I need to return this through a view

    notes acct
    ===========================
    txt1 1/1/00, txt3 1/3/00 1
    txt2 1/2/00 2

    I realize there are several ways to do this in a SP or function
    but through a view?
    Last edited by strany1; 04-21-08 at 22:12.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Use the view to call the function.

    -PatP

  3. #3
    Join Date
    Apr 2008
    Posts
    2

    thanks

    should have thought of that

Posting Permissions

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