First, is curr_time date-only, or does it have times stored in it? You have that in the Group By clause, so if it has distinct times stored in it,...

The way to do this would be to query your Universes table, then a sub-query of the Galaxies table, then a sub-query of the Objects table (or whatever this final...

Here's the problem with the "rush to get the thing out the door any old way" philosophy on software: How would you feel if you found out you were...

You're welcome.

And Lynn's change is necessary. I just copy-and-pasted that part, didn't even look at it, but it will end up with an error because of the conversion of...

Add a second CTE after the first one, have it sum up the prices from the first one, then in your final query, join the two together.

In management studio, if you open up SQL Server Agent on your server, there's a folder for Proxies. Right click that and select New. Follow the directions. ...

You'll get that error if some of the data in the spreadsheet is in the process of being updated. If it's "continually being updated", then you're going to run...

There's more to execution plans than just whether or not they use index seeks. You might need to look at how the joins are being done, and so on.

Also,...

You're welcome.

Access can't link on a zero-length string. Treats it as if it were null for that kind of thing. You might need to add an arbitrary string to...

I've used Response, and it worked well for me. Will probably get a copy for my new job in a couple of months, once a few other priorities have...

I guess I don't get why it would be insecure for the president to have a Blackberry or other smartphone. Don't put military or other sensitive information on it....

I've actually known a few people who were totally incapable of using a computer for their work, but who were good enough at their jobs that it was worth it...

If you join the results to a table with all the months in it, and use IsNull for the results, that might do what you need.

I may not be the right person to answer this, but the first thing that comes to my mind is: Do you mean that all queries are running on one...