Viewing 15 posts - 3,286 through 3,300 (of 3,507 total)
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
bad form. just post it.
the more eyes on your problem, the faster you get an answer.
October 2, 2013 at 11:23 pm
http://technet.microsoft.com/en-us/library/ms190307.aspx
look up "sp_send_dbmail" in BOL, or read the article...
October 2, 2013 at 11:20 pm
Viewing 15 posts - 3,286 through 3,300 (of 3,507 total)