GilaMonster (5/2/2011)

Ninja's_RGR'us (5/2/2011)

Jeff Moden (5/1/2011)

WayneS (5/1/2011)

BTW, I'm aghast --- you've actually used...

Jeff, I had to rate this article 5 stars, because that's as high as the ratings allow. It deserves a 15!

BTW, I'm aghast --- you've actually used a SQL CLR...

You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables...

Since you're only getting a previous row's value, and not actually doing a running total, this should work:

UPDATE t1

SET PreviousArea = CASE WHEN t1.System_Id = t2.System_Id THEN...

Jason,

Nice new avatar.

Edit: It goes with your nice, new handle.

Edit: posted advice won't work...

No problem. If you have any questions, just ask away. As the tagline in my signature states, don't use the code in production until you can understand what it's doing.

How's this work for you?

(You'll have to modify it to do the actual update; I'm just selecting the corrected data.)

DECLARE @CLI_CleanUp table

(CLI varchar(20))

insert into @CLI_CleanUp (CLI) values ('123456789')

insert into...

This doesn't handle non-numeric values that aren't at the start of the...

How does this work for you?

-- See how you start off by actually creating a table and then

-- inserting the data into it? Your doing this makes it a...

DECLARE @test-2 VARCHAR(20);

SET @test-2 = '1,2,3,16';

DECLARE @MyTestTable TABLE (RowId INT);

INSERT INTO @MyTestTable

SELECT 1 UNION ALL

SELECT 2 UNION ALL

SELECT 3 UNION ALL

SELECT 4 UNION ALL

SELECT 5 UNION ALL

SELECT 6 UNION ALL

SELECT...

;

WITH cteAddressIDOrder (AddressId, SortOrder) AS

(

SELECT 8, 1 UNION ALL

SELECT 1, 2 UNION ALL

SELECT 3, 3 UNION ALL

SELECT 2, 4 UNION ALL

SELECT 4, 5 UNION ALL

SELECT 5, 6 UNION ALL

SELECT 6,...

This is a Kerbosis error message...

I know this isn't PowerShell. From SQL, you could run this:

LEFT(@@SERVERNAME, CHARINDEX('\', @@SERVERNAME)-1)