I dont know why this works but it does except I cannot execute it from the Dataset page. It give me an error that @Count needs to be defined or Set is not valid
Set ROWCOUNT @Count
SELECT Prodid from Prod
@Count is a parameter and if I set it to 100 I get the 1st 100 rows, which is what I want. If I can run it from the Preview tab and it works why can't I run it from the Dataset tab.
Is there a better/correct way to structure the query
View Complete Post