Home Forums Data Warehousing Integration Services Using CTE with Parameters in OLEDB Data Source in SSDT (or why is SSDT so braindead?) RE: Using CTE with Parameters in OLEDB Data Source in SSDT (or why is SSDT so braindead?)

  • March 8, 2018 at 9:35 am

    #1982478

    Have you tried making it an inline table-valued function?
    I don't get why would you need a linked server to make it a view or how can you send parameters to a CTE inside a view. The problem might be on how you're calling this, but I have no idea of what you're doing.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2