Steve Jones - SSC Editor (8/24/2014)

---

Please don't use all caps. It is equivalent to yelling. Also please don't cross post (removed the other one).

You don't want to do this in...

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

KGJ-Dev (8/23/2014)

---

Hi, Below is the TestData,

With SalaryReport as (

Select 1 as IdSalary,100 as IDMainCompany , 1000 as IDSubCompany ,200000 AS Salary, 20000 as Incentive, 500 as...

Duplicate post. You have one in a SQL Server 2012 forum and another in a SQL Server 2014 forum?? What version of SQL Server are you running? ...

Duplicate post. You have one in a SQL Server 2012 forum and another in a SQL Server 2014 forum?? What version of SQL Server are you running? ...

Qira (8/23/2014)

---

Ok. This is my table

1- x_CV

CREATE TABLE [dbo].[x_CV](

[CVID] [int] NOT NULL,

[point_To_Score] [tinyint] NULL,

[score] [tinyint] NULL,

CONSTRAINT [PK_x_CV] PRIMARY KEY CLUSTERED

(

[CVID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE =...

Slowly getting more details.

rajeshjaiswalraj (8/23/2014)

---

JUST FOR EXAMPLE - i have two SQL server instance A and B.

From B i have to check A Instance is up or not. If not it has to...

Really??

If you expect to be running this procedure on the same instance it is supposed to be checking, not going to work. If the instance is down, the job...

Qira (8/23/2014)

---

I've table and data as follow,

CREATE TABLE [dbo].[x_Score](

[idx] [int] IDENTITY(1,1) NOT NULL,

[ApplyJob] [varchar](1000) NULL,

[r_ApplyJob] [varchar](1000) NULL,

[score] [tinyint] NULL,

CONSTRAINT [PK_x_Score] PRIMARY KEY CLUSTERED

(

[idx] ASC

)WITH (PAD_INDEX = OFF,...

Well, SPAM has over taken the Active Threads pages. Guess no one really needs much help this weekend.

Have you tried running the script in a sandbox database?

sku370870 (8/22/2014)

---

Sean Lange (8/22/2014)

---

sku370870 (8/22/2014)

---

Lynn Pettis (8/22/2014)

---

Sean Lange (8/22/2014)

---

brad.mason5 (8/22/2014)

---

Not sure if this is what you are looking for. This is assuming OrderID is the correct order you want.

SELECT...

Sean Lange (8/22/2014)

---

brad.mason5 (8/22/2014)

---

Not sure if this is what you are looking for. This is assuming OrderID is the correct order you want.

SELECT TaskID

,TaskDate

...