Select top (7 - (datepart(weekday, Fordate))) from table1

[MakingDBA]

Is there any way to get 'x' rows using a computed value in the 'SELECT TOP' clause. I know of the 'rowcount' way but that doesnot solve the problem as I am making this query in XML.

Please HELP!

Regards,
Not a DBA yet

[almaz]

Is there any way to get 'x' rows using a computed value in the 'SELECT TOP' clause. I know of the 'rowcount' way but that doesnot solve the problem as I am making this query in XML.

Please HELP!

Regards,
Not a DBA yet

SQL Server 2005 allows you to specify variable in TOP clause (previous versions don't allow it). So you have to:
1. evaluate the number of rows and assign it to variable
2. run SELECT TOP (@YourVariable) ... from ...