Search results for query: *

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...

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...

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...

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...