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...

It can be done but I agree with Lynn, kind of awkward doing this in SQL.

😎

DECLARE @IDMainCompany int = 100;

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

;With SalaryReport as (

Select...

Mail every minute and if it goes down then one can tell as the emails will stop:-D

😎

Sapen (8/22/2014)

---

Hello,

I have implemented transactional replication in sql 2012 with replicate schema changes. Now if I drop few indexes and add columns and re add indexes on articles in publisher...

Here is another suggestion on how to establish the grouping, the rest should be straight forward, select the last desired value from each group.

😎

CREATE TABLE #TEMP (T_ID INT IDENTITY(1,1),UserName varchar(20),Drink...

er.mayankshukla (8/23/2014)

---

I would not suggest you to use DBCC ShrinkDatabase, but should see the query which is creating this.

In one of my projects I observed such a behaviour when I...

Quick analysis

😎

First a simplified ERD

+--------------+ +--------------+ +-----------------+

|...

JeeTee (8/22/2014)

---

Wow, that works quite well. Given that I discovered some flaws in my post where I thought I had it with the quirky update, I'll try using this against...