Search results for query: *

Got it. That works, thank you for your help!!

Right, that's the problem. The where clause I'm using is not including the 2009 student. I want to only max the duplicates and leave the students that are not duplicated and may fall in another grad year. SELECT StudentID , rtrim(First) + ' ' + rtrim(Last) As [Student Name] , YOG...

I want the result to look like: StudentID Student Name YOG SchoolYear 200001 YARITZA SANCHEZ 2012 2010 200002 RAFAEL ARRENDOL 2013 2010 200004 SURIA BONILLA 2013 2010 200007 BRIANNA CHAVANNESSMIT 2014 2010 200050 AARON ISRAEL...

Hello, I have a query result that looks like: StudentID Student Name YOG SchoolYear 200001 YARITZA SANCHEZ 2012 2009 200001 YARITZA SANCHEZ  2012 2010 200002 RAFAEL ARRENDOL 2013 2009 200002 RAFAEL ARRENDOL  2013 2010 200004 SURIA BONILLA  2013 2010 200007 BRIANNA CHAVANNESSMIT 2014...

I think that's a good option. Thank you for your time.

Below is the SQL and it utilizes Oracle linked tables. SELECT tblappl.[DR#], tblappl.STATUS, tblappl.CDR, tblappl.APPLDT, tblappl.DUEDT, tblappl.MA, tblappl.TA, tblappl.EA, tblappl.MEDCLAIM, tblappl.PSYCHCLAIM, tblappl.[APPL#], tblappl.NOCE_ AS NoCE, tblappl.TYPE_ AS Type, tblappl.MAM...

This query is utilizing linked tables. It is not a pass-through. The problem is that this company doesn't want to spend resources on developing Oracle based views or procedures for the department. Crazy, but they may have to.

Hello, I have an Access front-end/Oracle back-end. One of the queries got an ODBC--failed error today. I re-created the query, in fact, slimmed it down. It works, but takes the user 15 mins to open, takes me 2 mins. The user is one town over, I am one floor above the servers, not sure if...

I am using SQL Server 2005. Not sure this issue is related to Windows 7.

Hello, My company recently upgraded to Windows 7. Now when my clients open report server they get a logon page. What do I need to do to get rid of the logon page. Thank you!!