My experience is similar to what you describe. I started out using the plural, and I think mostly that's what I inherited, or learned. As I began to design my...

I have great respect for the site for owning the mistake and giving credit where it is properly due.

/* Find the first and last dates for each object */

;WITH MeterVolume...

We had a similar instance, where a linked server that once functioned for certain users stopped functioning. Our solution was actually to increase the permissions on the Windows server for...

UncleJimBob (8/31/2010)

---

I ran into performance issues caused by parameter sniffing so many times using this type of construct

at work that I had to stop using it.

Now I use this:

declare @local_firstname...

I use the...

Nice article. I've been using this methodology for sometime, and I'm pretty sure it was here I was first sent stumbling in the right direction. This sums it up nicely.

How would one go about grouping by dates, i.e. month, year?

So a query from 12/30/2009 thru 1/2/2010 would have something similar to this.

Meter Day ...

The .dqy file is very limited. The query text itself cannot even have a line break.

However I use named ranges to create graphs that change with the result of...

Right click on the toolbar and select Customize.

On the Commands tab, select Data from the Categories list. You should then be able to find 'Refresh All' in the Commands...

You would need to uncheck the auto-refresh option on your parameters dialog, and use the Refresh All button after changing both parameters. I add this button to my standard toolbar...

I use this script to start sql agent when the sql instance starts

/****** Object: Stored Procedure [dbo].[StartSqlAgent] Script Date: 12/22/2008 11:13:02 AM ******/

USE [master];

GO

SET ANSI_NULLS ON;

GO

SET QUOTED_IDENTIFIER ON;

GO

IF...

My resolution to this issue was to use %26 in the database for an ampersand, then replace it on the client end with '&'

Excel 2003 by default puts them in My Documents > My DataSources. At least on my machine, but that could be an option on our corporate image. I just create...

That sort of inconsistent behavior in MSQuery is exactly why I edit my .dqy files manually as described early on in this thread.

It looks like IE and FF display this differently.

Basically I want the result of FOR XML not to have any 'amp;' in the result when an ampersand is present.