i found

From: Artek Siara <artursiara_at_poczta.onet.pl>
Date: Thu, 14 Apr 2005 14:06:35 +0200
Message-ID: <d3lmca$6a8$1@galaxy.uci.agh.edu.pl>

BTW
that row:
> ROW_NUMBER() OVER (ORDER BY 'NAME' ASC) AS rownumber,

should be as                                                without '

ROW_NUMBER() OVER (ORDER BY NAME ASC) AS rownumber,

regards
Artur Received on Thu Apr 14 2005 - 07:06:35 CDT