SQL Server Performance Forum – Threads Archive

how to get multiple records using READTEXT

Hi I have following query DECLARE @ptrval varbinary(16)
SELECT @ptrval = TEXTPTR(T.request)
FROM TQueue As t
READTEXT T.request @ptrval 1 580 Here request is in XML format
1) how can i retrieve multiple rows from the above request.
2) is there any other way in which i can retrieve the output

---

Could this help? From BOL 1)
USE pubs
GO
SELECT pub_id, TEXTPTR(pr_info)
FROM pub_info
ORDER BY pub_id
GO 2)
USE pubs
GO
SET TEXTSIZE 8000
SELECT pub_id, pr_info
FROM pub_info
ORDER BY pub_id
GO Luis Martin
Moderator
SQL-Server-Performance.com

---

And may refer to thishttp://www.kbalertz.com/Feedback_317034.aspx link. HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

]]>