Can you add a parameter for returning one result set or the other to the sp that's being called?

There was a man at a restaurant in Paris asking about a dish that contained both rabbit and horse. The more rabbit in it, the better the dish. ...

One place I would start with this is to run the SP by itself in SSRS. You can do this by opening up the query designer in the dataset...

Wayne, yes! More like this. This is right on target. :smooooth:

The CAP was interesting, so all a good RDMS would have to do is make it partition tolerant and the NOSQL would become completely superfluous? 'I suppose that's easier...

Thank you for the article Gail. Your technical explanations are outstanding - very straightforward. It amazes me when someone so advanced in a field can also get down...

Luke L (1/6/2011)

---

Yeah I heard about it... 17K users seems like a lot to some, but in the scope of MS's hotmail users that as the article stated was a...

But, Craig, you're still trying to divide a non-pie. :laugh:

Logically, that's nonsense - 'can't be done. To me, you can't take nothing and divide it by...

Craig Farrell (1/6/2011)Zero was really just a placeholder, since spaces were a pain and the Arabs started using a simple dot to hold the place in larger numbers. No,...

Tom, in a conceptual way I sort of get the fact that zero divided by any other (real) number equals zero. But logically, I don't know why we can...

Brandie Tarvin (1/6/2011)

---

Tom.Thomson (1/6/2011)

---

Some of the tricks that the owners have played from time to time with terms and conditions and with privacy features buried so as to be almost...

kevlray (1/6/2011)

---

I need to upgrade my PC. In the past years I went to Pricewatch.com and looked for motherboard combos. That way I know the the MB, CPU...

'Went to a high school reunion recently and it seemed as though everyone knew what was going on with everyone else but me. They had all been on Facebook,...

'Makes perfect sense Jason, thanks again.

- Mark

Well thought-out and illustrated Jason, thanks! 😎

So should we always check queries returning just a few rows to see if a forced Nested Loop would help?