Search results for query: *

hm. thanks iker3000. that's what I did in the end. I don't like using temp tables if I can avoid it, especially not here, as I expect this procedure to get a lot of activity. I tried inserting into a table variable, but it wouldn't allow me from an execute, The only way of keeping this in...

you can't order a view. a view is a filtered rowset. if you need to order the data, you should order your select * from my_view statement instead. If you want it automatically ordered, you might consider building appropriate indexes on the underlying table instead. Even if doing this doesn't...

This feels like it should be obvious, but it's escaping me just now. I have a particularly complex stored procedure that runs dynamic sql to return a dynamic result set. I now want to select a subset of rows and columns from a known set of results. in theory, I need to do something like...