C'mon Jeff.

If you write a book I'll volunteer to help to proof-read it. I doubt that I'll have much work to do because the task of contributing to forums sure...

It's OK, Peter; I don't mind people disagreeing with what I say. Any ideas that can be brought to bear against the problems of application resilience in the face of...

For the definitive answer on how to do the reverse, read this.

http://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/

The Happy Pill

[font="Courier New"]

CREATE TABLE t1

(

eno CHAR(2) COLLATE SQL_Latin1_General_Cp437_CS_AS NOT NULL

   CONSTRAINT c1 CHECK

   ( eno LIKE

   '[ABCDEFGHIJKLMNOPQRSTUVWXYZ][ABCDEFGHIJKLMNOPQRSTUVWXYZ]'

   COLLATE SQL_Latin1_General_Cp437_CS_AS)

)

INSERT INTO t1 VALUES ('dF')

INSERT INTO t1...

I don't think there is any way of doing this other than a trigger, and I'm not sure why the use of a trigger will affect the replications.

you can specify the collation in a LIKE clause.

OOh yes. SQLCMD! I agree wholeheartedly that it is an essential for quickly automating complex processes across several servers. I love it. It is so good that one is...

I shall cherish the expression of the robot in the first frame for a long time.

That should be

[font="Courier New"]SELECT t1.DID, t1.ID, min(t1.value) as value, sum(t2.Value) as output FROM @Table t1

left outer join @Table t2 on t1.DID=T2.did

and t2.id between t1.id+@StartPosition-1 and T1.id+@endposition-1

group by...

OK then..... How's this

DECLARE @Table TABLE

([DID] INT,

[ID] INT ,

[Value] INT)

DECLARE @startposition INT

DECLARE @endposition INT

SELECT

@startposition = 2,

@endposition = 3

INSERT INTO @Table

SELECT 1,1,2 UNION ALL

SELECT...

You can do it without a number table though I'd love to know what the @startPosition variable does...

DECLARE @Table TABLE

([DID] INT,

[ID] INT ,

[Value] INT)

DECLARE @startposition INT

DECLARE @endposition INT

SELECT

...

David,

I got a strange feeling of doom when the Codeplex project to revive NorthWind started. It seems very quiet now. A sample database needs an immediate purpose. It has got...

Interesting discussion.

A short while ago I watched a recording of President Eisenhower's parting speech, where he warned of the 'military/industrial complex'. Times are very different now, but here was...

Phil, I'm really not sure what you are arguing for here.

A friend of mine was mistakenly put onto a government database in the UK because he has the same name...

You're kidding, right? I have a hard enough time warning developers with computer science degrees about the risk of insecure applications, let alone the guy at the cafe who...