I'd say it depends on what else you expect from the individual or company providing you with the offsite monitoring services. Monitoring is just one aspect of what is...

Luis Cazares (7/8/2014)

---

I might be wrong, but this is a shot in the dark. Aggregate functions (including MAX) exclude null values. If you're using MAX() and replacing it with '1900-01-01'...

I reformatted your code and eliminated the 3 part naming in the select list, ON, WHERE, and ORDER BY clauses. You should avoid this as it is deprecated and...

Already determined that. ...

And we asked for the same info in both threads as well.

But, with as little to go on we need the extra info.

Already using this one though, and I didn't see the other until I got into work this afternoon. I'd seen this one early this morning. All times Afghanistan...

Sean, saw that and asking to use this thread for replies. I am also asking that this thread be moved to a SQL Server 2008 forum.

Double posted request for assistance. You already have this posted in a SQL 7/2000 forum (where, by the way I asked what version of SQL Server you are actually...

Also, if you update the values in place, look what happens if you run the STUFF(RIGHT...)) against the modified values:

create table dbo.test(

testid int identity(1,1),

...

This help any?? By...

C-kweldude (7/7/2014)

---

Hi Guys

I need a bit of help.

I have a column with integer records of 5 and 6 characters.

example below od 2 records.

12345

123456

What I need to do is

1. If...

First, you posted this in a SQL Server 7/2000 forum, so big question is what version are you using?

Second, with just a code snippet it is difficult to know what...

Mile Higher Than Sea Level (7/7/2014)

---

Id_Wells on Wells table is an PK (unique)

I totally forgot to include R_35 - thanks for the reminder.

As per my Missive above...

This Discrete Rule...

I don't know, looks like there was a drive failure on a production database, needed to replace a drive, restore the database to a point in time, using a tail...

Mile Higher Than Sea Level (7/7/2014)

---

CREATE FUNCTION [dbo].[R_35A](@ID_Wells int)

RETURNS int

AS

BEGIN;

DECLARE @Result int;

SELECT @Result = SIGN( COUNT(*) )

FROM Wells

...