Always more than one way to skin a cat, even if it is the wrong thing to do.

Biggest unanswered question asked so far is why is this needed? Maybe...

No group by needed., forgot to take off the MAX.

WITH BaseData AS (

SELECT

...

More like a picnic problem. That's what I get for writing code on a smartphone.

Thanks for catching the missing parens.

Olive (the other reindeer).

momba (2/5/2013)

---

RE: Lowell's post....results are still too high... when I try to follow your logic in the code I get lost in the syntax around "GROUP BY" so I started...

Something like this:

SELECT

dt2.q1,

dt3.q2

FROM

(SELECT 1) dt1(n)

CROSS APPLY (SELECT COUNT(*) FROM dbo.Customers) dt2(q1)

...

momba (2/5/2013)

---

I've got another noob question...

When I run this query to just grab the emp_id I get 6474 but when I request more fields I get 6605?

select distinct CONVERT (varchar(9),EMPLOYEE_ID)...

shloghomes (2/5/2013)

---

Apparently this only effects the SQL log files.

I want to eliminate the SQLSTATE 01000 messages from the Backup command when calling it from a SQL Agent job. The output...

Not sure what /pit is, but shouldn't the date be in quotes, like this: "2013-01-29"?

You may need to check your Tivoli documentation to be sure of the switches you...

Whoo Hooo! DTA to the rescue!!

Also, still don't see DDL for the tables, indexes, or views, nor have I seen an actual execution plan. How many shots in the dark do you want before...

Once more...

Also, have you tried using the NOEXPAND query hint when querying your indexed view?

First, the query posted isn't an indexed view (has parameters in the query).

Sorry, just caught that those were commented out. The rest of this still stands.

Second, without table and...

Okay, had to go purchase a new power supply as the none of the unused PCs I have had a viable power supply to swap in for the blown one....