that and the windowing functions.

Thanks!

I had a disaster like this once, but it was in [ick] Access. After I restructured and showed them how simple it was to query, they were sold.

petronas40 (10/22/2013)

---

I have to extract the record which has 6 numbers which are together from the string .

Customer ID Address

6237 ...

Just thinking...

what if you did a summary on this:

iphone_id,

seriel_number,

max(date_assigned),

and then joined that result back to the table to return the rest of the info you need?

so

max(date_assigned) = assignments.date_assigned

and...

Use MAX

Group by the stuff before the dash.

CAST the stuff after the dash as a number, get MAX of it.

I have a report which has times in the following format: (11:20:01). I need to have a subtotal row added which has an AVG of all the times. I am...

Having Access able to see/modify data in your database is a terrifying idea, IMO. You might be safe if you grant the users ReadOnly access, but a knucklehead with...

Client want read/write access to all authenticated domain users on table in database .

Explain to them the potential problems with complying with such a request. There are good reasons...

If these are columns in your query...

[Ship To Dealer],[Car Line],Status,Count

SELECT [Ship To Dealer],[Car Line],[Status] As BadReservedWord, COUNT(*) AS LineCount

FROM MyTable

ORDER BY [Ship To Dealer],[Car Line],[Status]

GROUP BY [Ship To Dealer],[Car Line],[Status]

Post enough information so that people can help you.

1. Table definitions (right-click, script CREATE TABLE... to clipboard)... paste here.

2. Some data (a few records - enough so we know what...

Can't you go into SQL Server and create a job to run a bunch of them in sequence? Then schedule them using the Job?

Could you use Soundex for this? And any comparison that has a score within an "acceptable" range (open to interpretation) would automatically update. You could probably do most/all...

subclass? One table for Square, one for Circle. Get the entity ID from the parent table?

You can't create linked servers and do the union in your stored procedure?

I'm getting smarter finally!!!

Took long enough!