Thanks, that did the trick...

Thanks a bunch, that is just what I needed

Thanks, that did the trick..

Ok, here's the way things are laid out in my table. I hope this makes sense. What I'm looking to get is to obtain the Student ID of...

Cadavre

That is exactaly what I needed. Thanks a bunch.

Cadavre, that is correct. I need to get the results

Here's what I've been able to get so far. I can get the results by running one query or...

Thanks, I think I have what I need now

Thank you... worked like a charm

this is what I ended up using for those who wish to know

exec sp_MSforeachdb 'if ''?'' NOT IN(''master'', ''tempdb'', ''model'', ''msdb'')select field_a, field_b...

Thanks for pointing me in the right direction. With a bit of research I came up with the following

exec sp_MSforeachdb 'select field_a, field_b from [?].[dbo].[tblname] where DB_NAME() NOT IN(''master'',...