select Intervention_text from cwsavpmtest_live..system.Intervention_data

SELECT *
 FROM OPENQUERY(cwsavpmtest_live, 'select left(Intervention_text,32395) from Intervention_data’)

CREATE TABLE #Intervention_Data 
 (ID                    varchar(254),
  FACILITY              Int,
  INTID                 Int,
  Intervention_Text     varchar(4000),
  Intervention_Name     varchar(50))

SELECT @QueryString = 
         'INSERT INTO #Intervention_Data SELECT * FROM OPENQUERY(' + @LinkedServer +
         ',''select ID, FACILITY, INTID, left(intervention_text ,4000), ' +
         'Wiley_Intervention_ID from Intervention_Data where facility = ' + 
          cast(@FACILITY as varchar(10)) + ''')'

EXEC(@QueryString)

SELECT *
 FROM OPENQUERY(cwsavpmtest_live, 'select Convert(Varchar(4000), Intervention_text) as Intervention_text from Intervention_data’)

quote:

---

Originally posted by harsh_athalye

What's the result of the below query?

SELECT *
 FROM OPENQUERY(cwsavpmtest_live, 'select Convert(Varchar(4000), Intervention_text) as Intervention_text from Intervention_data’)

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

---

quote:

---

Originally posted by Kristen

Put a stored procedure on cwsavpmtest_live..system which returns just the first, say, 4,000 characters of that column, and call the Sproc (on that server) instead of querying it directly?

But I am struggling with the concept that you cannot query that table directly.

Just to check: the Current database and the remote / linked one are BOTH SQL Server database?

Kristen

---

quote:

---

Originally posted by Kristen

Ah, I see, sorry didn't twig that.

Might be an issue with its ODBC driver then?

Kristen

---