How can I achieve this without using Dynamic SqlQuery?
I have this Query,
SELECT TOP n FROM mytable WHERE ID = @id
To get the value of n,
SELECT nCOUNT FROM myAnotherTable WHERE ID = @id
Can I use Row_index() for this?
可以将文章内容翻译成中文,广告屏蔽插件可能会导致该功能失效(如失效，请关闭广告屏蔽插件后再试):
问题:
回答1:
Try like this....but make sure that your select ncount return single row.....if not than it will select top row ncount
SELECT TOP(SELECT TOP 1 nCOUNT FROM myAnotherTable WHERE ID = @id) * FROM mytable WHERE ID = @id
SqlFiddle: http://www.sqlfiddle.com/#!3/75c76/1
