Not sure if this would be better handled in the vb.net section but here goes.

Is there a way that I could call a single stored procedure that has multiple selects in it and easily assign them to their own datatable within a dataset?

So one stored procedure would be basically the datasource for multipe datatables?

Or should I just stop being lazy and break them up?

Thanks

Blah wrong forum... please move to database section