Posts   
 
    
Jeff M
User
Posts: 250
Joined: 04-Aug-2004
# Posted on: 21-Oct-2005 19:36:51   

Frans - is LLBLGenPro ready to produce SQL Server 2005 queries that use Common Table Expressions?

Thanks.

Jeff

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39933
Joined: 17-Aug-2003
# Posted on: 21-Oct-2005 20:39:23   

No, that's for 2.x. I first have to study on CTEs and when to use them.

Frans Bouma | Lead developer LLBLGen Pro
pilotboba
User
Posts: 434
Joined: 05-Aug-2005
# Posted on: 21-Oct-2005 20:51:27   

Don't forget creating efficient paging with the RowNumber feature.