Steven Cameron (6/23/2008)

---

When the question of the day is incorrect, everyone keeps posting the same thing over and over. Maybe we should have a standard reply form:

-------------------------------------------------------------------------------

I selected ...

I was a bit hesitant to answer this one as I noticed there were checkboxes instead of radio buttons, and I thought to myself, "Hmmm... there's only one right answer,...

Someone else will have to help you out with the specifics on truncating/specific maintenance, but here's some spaghetti code for looping through databases and tables...

DECLARE @DBName varchar(128)

DECLARE databases CURSOR FOR

 SELECT...

I agree with sam.  This table design needs some help.  If you really must do what you're suggesting here, this is the only way I can think of, and I'm...

I'm right with Kathi.  If any of the stored procs being called in the cursors (AB_FINANCIAL, AB_OVERDUE_BALANCES, or AB_RECONCILIATION) modify the table structure of either FilesInDirectory or INTERFACEFILENAMES, you'll get...

Whoops, my bad...  That's what I get for not testing out my solutions beforehand.

SELECT

OuterQuery.ID

 , OuterQuery.School

 , ISNULL( OuterQuery.EndYear, '' )

 FROM #INSTITUTIONS_YEARS OuterQuery

  INNER JOIN

   ( SELECT ID, MAX( ISNULL(...

You could try this replacing YourTableName in both places with your table name.

SELECT OuterQuery.Id

 , OuterQuery.School

 , ISNULL( OuterQuery.EndYear, '' )

 FROM YourTableName OuterQuery

  INNER JOIN

   ( SELECT Id, MAX( ISNULL( EndYear, '' )  )

    FROM...

Resurrecting this thread from the dead because I have questions for you, Jeff.  It sounds like you're referring to a SQL Server solution here, but Ben was asking about Access. ...

You might have to write an EXEC statement, but it looks like you're trying to do this from ASP.  I'm not completely familiar with doing this sort of thing in...

Well, this changes everything.    Try this...

SELECT COid, BIid, BRid, COofficeName, CMclientName, BRrate AS 'Client Rate',

BIstandardRate AS 'Standard Rate', BIdescription

FROM billrate A, clientoffice,...

Without seeing the larger query, it's a bit hard to determine why you're getting that error.  Are you using an IN to introduce the subquery?

Haha!  Not really.  It's just that I wrote a very similar query for someone else today over in this thread, and I figured I could just reuse it just...

You have a good point, mrpolecat.  I'll bet that's the issue.  However, if Magy wants to keep BRid in the query, it complicates it quite a lot, but it is...

SELECT OuterQuery.mytable_pk, OuterQuery.col1, OuterQuery.goods, OuterQuery.maxval

 FROM mytable OuterQuery

  INNER JOIN

   ( SELECT goods, max(maxval) as maxval

    FROM mytable

    GROUP BY goods

    ) InnerQuery

   ON OuterQuery.goods = InnerQuery.goods

   AND OuterQuery.maxval = InnerQuery.maxval

In order for this to work, all the OrigCounty data must have the data exactly as you suspect... (County, State).  If you have a null or a blank or maybe...