I think there's a big caveat when using a model of deploying early and often. This approach can too easily lead to a culture where the early adopters of...

if you want to see the stats the database has collected over time for this stored proc, instead of just testing one time execution, you could use the DMVs:

SELECT

...

I think part of the problem with SAN pools is the inherent disconnect between how network guys setup disk arrays and luns on these devices and how database people want...

Somewhere in my basement is a box that has old hard disks, going back to when they were only 2 gig in size. Only ones that I've ever let...

There's a script available from Microsoft to assist in generating a file that you can use to recreate the logins and same passwords on a different instance. I've used...

of course this will fail misserably on every table that...

I suppose the best way to decribe it is that a foreign key relationship requires a primary key or unique constraint on the referenced column in the referenced table, so...

tanvishriya (12/12/2012)

---

-- Creating Unique constraint on [ESId] in table 'ES'

ALTER TABLE [dbo].[ES]

ADD CONSTRAINT [IX_ESID] UNIQUE ( [ESID] )

GO

-- Creating foreign key on [EStId] in table 'ES'

ALTER TABLE [dbo].[ES] WITH...

OK, so if I'm understanding this...

Actually Sean's code will give you the counts you're looking for, and in a more efficient manner than trying to get each one separately using the variable. If the...

The problem is that SQL Agent is the program you'd typically use to do monitoring and alerting. It sounds like what you really need is some kind of watchdog...

narendra.kongara (12/11/2012)

---

1> -- Correlated subquery using the department table in both inner and outer queries

2>

3> SELECT t1.*

4> FROM department t1

5> ...

seems simple enough, your dates should be in the WHERE clause, not GROUP BY clause, like this:

SELECT sName, SUM(sinterventions) AS sinterventions, SUM(sareas) AS sareas

FROM mytable

WHERE DateValue...

no problem, you made it easy for people to help you by posting the script with the CREATE, and INSERT

if you don't want to group by dept, then the SUM needs to be outside the CASE structure, like this:

DECLARE @FYStartDate AS DATE

SET @FYStartDate = '2012-07-01'

SELECT PPDate, --Dept,

...