Good job with the data sample. I wouldn't be too concerned about the size of the SP code, the main concern is to get it working;-)

The following code toggles between...

So the heavy handed single user mode...

Are you using the ONLINE option? If you are, the additional resources required might be part of the problem. If not, in might...

Lynn Pettis (8/23/2014)

---

Eirikur Eiriksson (8/23/2014)

---

rajeshjaiswalraj (8/23/2014)

---

I HAVE TO WRITE ONE STORE PROCEDURE THAT EVERY MIN IT HAS TO CHECK MY SQL INSTANCE IS UP AND RUNNING IF NOT IT HAS...

I am striving to maintain the readability of my code;-)

My concern at this point would be the 4 table scans rather than...

Hmm???

😎

BTW +100 for the soapbox...

Out of plain curiosity, what is this database used for?

😎

rajeshjaiswalraj (8/23/2014)

---

I HAVE TO WRITE ONE STORE PROCEDURE THAT EVERY MIN IT HAS TO CHECK MY SQL INSTANCE IS UP AND RUNNING IF NOT IT HAS TO SEND MAIL. PLEASE...

Quick question, what edition of SQL Server are you on?

😎

You are right, since the aggregation is on the outer/later query, no grouping is needed on the inner one.

😎

This is a fundamentally flawed design, including operators in a column, let alone combining operators and values in a single column is seriously wrong. First suggestion is to amend the...

Here is a quick attempt, please check the results;-)

😎

DECLARE @IDMainCompany int = 100;

DECLARE @Process_Date datetime = '2014-01-01';

;With SalaryReport as (

Select 1 as IdSalary,100 as IDMainCompany , 1000...

Indu-649576 (8/23/2014)

---

Here im trying to cast the dynamic sql into varchar .when I run the below is still displaying xml result set only.

It is not casting to varchar.I need the...

Shadab Shah (8/23/2014)

---

Hi Eirikur,

🙂 your example was a good learning , Thanks.

Mr.Eirikur , Do you know some good article which are good to understand Grouped Set, Of Course google is...

Shadab Shah (8/23/2014)

---

Hi Eirikur,

I have being trying to help OP with this question with the help of your solution.

I think the grouping in your solution is incorrect.

If we consider the...