Search results for query: *

Thank you!!!

Hello, I am querying the Catalog table in the ReportServer for column [Path] which houses the location of a report. I want to parse that to return only the main folder. So the data reads /CSS/Management. I only want CSS. Can anyone direct me how to do that. This is what I have so far, any...

I figured it out. Thanks anyway!!

Hello, I'm using the following query to get the below results. SELECT MtgID, ClientID, Answer_Text, CreatedDate FROM Results MtgID ClientID Answer_Text CreatedDate 3025040 2190 No 1/12/2010 3025040 2190 No Response NULL I need to group the...

Okay, thanks for the CGI information. I have a better understanding. The languages the host supports is PHP and Perl. They have Linux servers. Does this help?

CGI is definitely supported and .Net might also be available. I'm new to web development. Thank you for your help.

Hello, Not sure if this is the correct forum for this question. Through my website, I need to allow a user to enter a number and open a corresponding .pdf. The .pdf name looks like 'TR-0433 72689 to 72864' and the user can enter a number anywhere between 72689 amd 72864. Can anyone direct me...

Hello, My organization is migrating to MS Access 2007 and Windows 7. When I open our .mdb file in that environment my access workgroups are stripped out. Since .accdb doesn't recoginize workgroups, I'm thinking that I might want to not use Access security at all going forward. Any advice or...

Thanks again guys. I knew I had to do a Case statement, but couldn't get the right outcome.

One more question. How do I handle if Review1 is NULL So the data looks like: StudentID Review1 Review2 228017 12/30/2008 NULL 228017 NULL NULL The result I get in this case is below, when I would now want to put NULL in review2 StudentID Review1 Review2...

Thank you guys for your help.

Makros, I'm sorry. Yours would have worked, I didn't see Review1 on the second field. I apologize.

That worked! Thank you so much.

I tried that and I get StudentID Review1 Review2 228017 12/30/2008 NULL Thanks for responding

Hello, My data looks like: StudentID Review1 Review2 228017 12/30/2008 NULL 228017 3/12/2009 NULL I want it to look like: StudentID Review1 Review2 228017 12/30/2008 3/12/2009 I'm using a simple SELECT StudentID , max(Review1) , max(Review2) FROM...