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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by kevinbk

  1. kevinbk

    passing parameter based queries to remote linked servers...

    Yes, I found a reference to heavily single quoted methods. I forget where. But, the following query is based on that approach and I was able to get it to work and with a little tweaking I greatly reduced the number of quotes in the query... declare @someSQL VARCHAR(200) declare @somePATID...
  2. kevinbk

    OPENQUERY vs. select * from Server.db.dbo.table

    Are you sure that the "fact table" transfer is the actual data table and not some sort of schema definition transfer or reference validation? The problem I have with OPENQUERY is that it doesn't allow parameterization of the query string. The problem with the 4 part naming convention method is...
  3. kevinbk

    passing parameter based queries to remote linked servers...

    The question is not how to reference a linked server or any tables it may contain. The question is how to pass query parameter values. And I will note that not all linkable remote servers and their databases support 4 part naming conventions, and yet they are still queryable. It is on the...
  4. kevinbk

    passing parameter based queries to remote linked servers...

    How do you pass parameter based queries to remote linked servers from SQL*Server? It seems like such a basic functionality that it must be within SQL*Server to call remote non-SQL*Server data sources with a parameter. OPENQUERY doesn't accept parameters within the query string portion, so the...
  5. kevinbk

    Annoying Error

    So what was the solution?
See more

Part and Inventory Search

Back
Top