Okay, I'll take a look at that. Maybe the dba here will set one up, but I doubt it. Does anyone know of a way of doing this w/o odbc?

I'm looking to do a windows integrated. I'm looking into the ODBC option now, but does that require that a DNS be setup? The dba here is requiring me to...

Maybe my only issue is the aliasing part and that if I could determine all the individual columns in "w.*" I could simply alias all of them dynamically, which would...

Yeah, I'm definitely trying to stick with core functionality in order to make this last. My issue with the above solution(s) is that my conversion function must be dynamic in...

So it is! Let me try adapting my query and see how it works...

Removing the w. in the order by works, but I need to sort by that unfortunately. The ROWCOUNT solution would work, but SQL SERVER 2005 is not an option right...

Thanks for your reply! Trying the query you suggested works. I tried replacing w.* with w.wid in my query, but that threw the following error (the same goes for if...