Looks like this will do exactly what I need.

Thank you very much

Florian Reischl (5/21/2009)

---

Bruce (5/21/2009)

---

Here is some sample data that might help.

mike, 05/21/09, 1, 0, 0, 1, 0

bruce, 05/21/08, 0, 1, 1, 0, 0

john, 09/09/09, 0, 0, 0, 0, 1

I guess...

Florian Reischl (5/21/2009)

---

Hi Bruce

I'm still quiet unsure if I got you but let's give it a try (works only with temp tables)...

As I understood the returned columns shall depend on...

Lowell (5/21/2009)

---

dynamic results means dynamic SQL. there's no other way to do it.

if you only have read access, you could not create a stored procedure to run dynamic sql anyway,...

Florian Reischl (5/21/2009)

---

So let's start with the "any questions" :hehe:

1.)

What do you mean with "create a process"? A procedure? A .Net app? A web-app? PHP? Cobol?

2.)

I don't really understand your...