Viewing 15 posts - 3,256 through 3,270 (of 3,479 total)
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...
October 22, 2013 at 8:48 pm
Use MAX
Group by the stuff before the dash.
CAST the stuff after the dash as a number, get MAX of it.
October 21, 2013 at 2:58 pm
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...
October 20, 2013 at 7:14 pm
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...
October 17, 2013 at 11:26 pm
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...
October 17, 2013 at 11:20 pm
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]
October 17, 2013 at 2:10 pm
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...
October 17, 2013 at 2:08 pm
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?
October 17, 2013 at 12:46 pm
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...
October 16, 2013 at 8:47 pm
subclass? One table for Square, one for Circle. Get the entity ID from the parent table?
October 14, 2013 at 12:51 pm
You can't create linked servers and do the union in your stored procedure?
October 6, 2013 at 6:29 pm
I'm getting smarter finally!!!
Took long enough!
October 5, 2013 at 5:46 pm
You might be able to use JOIN() in SSRS, but Sean's right... more details, please!!!
If you want a good answer, ask a good question! (enough details so we can reproduce...
October 4, 2013 at 5:00 pm
Maybe someone more knowledgeable than I will chime in, but what if you did this with a cursor and scheduled it as a job? (so it runs in off hours)....
October 4, 2013 at 4:55 pm
only thing i can think of is to do the iffy one inside a TRY/CATCH block and trap for the table not being available (if you can). Then use...
October 2, 2013 at 11:59 pm
Viewing 15 posts - 3,256 through 3,270 (of 3,479 total)