CTE

Last Post 05 Apr 2006 11:30 PM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Sungard
New Member
New Member

--
17 Jan 2006 02:47 AM
Hi,

I am trying to replace a cursor with a CTE. Is it possible to scroll through the records returned by the CTE?

TIA

Jamie...
SQLUSA
New Member
New Member

--
05 Apr 2006 11:30 PM
Yes, but your last line should be like:

WITH cteX
....

SELECT * from cteX

Kalman Toth, Database, Data Warehouse and BI Architect
http://www.sqlusa.com
The Best SQL Server 2005 Training in the World
You are not authorized to post a reply.

Acceptable Use Policy