Can "OpenDatasource" with the in Memory data.

• nRk-409197

  SSC Journeyman

  Points: 87

  More actions

  May 13, 2008 at 4:25 am

  #186473

  Hi,

  I am using the following query retrieve the data from a flat text file. The text is tab delimited.

  The same content is also available in a table.

  Now I am writing content in to a file in local disk and accessing , instead of doing this can I directly use the output of another query which gives me the same content what is there in the local file.

  SELECT *

  FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0', 'Data Source="D:\testingFolder";Extended properties=Text')...RespnsePract#txt

  Is there any other way. to query in memory text, which tab delimited.

  Thanks

• Matija Lah

  SSCertifiable

  Points: 6429

  More actions

  May 30, 2008 at 2:31 am

  #822144

  You can reference the current query as a derived table in your main query.

  For a more accurate answer, please, provide more information regarding your actual business requirements.

  ML

  ---
  Matija Lah, SQL Server MVP
  http://milambda.blogspot.com