This is a job for patexclude8K.

CREATE FUNCTION dbo.PatExclude8K

(

@String VARCHAR(8000),

@Pattern VARCHAR(50)

)

/*******************************************************************************

Purpose:

Given a string (@String) and a pattern (@Pattern) of characters to remove,

...

As others said, more details: good, cursor for this: bad.

It sounds like you can accomplish what you are trying to do with two update statements.

For a great tutorial try the Stairway to SQL Server Reporting Services[/url] right here on SSC.

Using this DDL and sample data:

USE tempdb

GO

CREATE TABLE dbo.[ACTION]

(

actionid int not null,

actionvalue varchar(100) not null

);

CREATE TABLE dbo.ACTIONRESULT

(

resultid int primary key,

actionid int not...

Thomas Schutte (5/15/2015)

---

In this case I would use a simple tally table:

DECLARE @source TABLE (SegNo int, Date_Field smalldatetime, Month_Count int, Payment decimal(10,2))

DECLARE @tally TABLE (N int)

INSERT INTO @tally(N)

SELECT ROW_NUMBER() OVER...

Thank you for the kind words Iwas

GilaMonster (5/14/2015)

---

Question for the people here...

Over the years I've been very careful to keep my blog completely non-commercial, no adverts, no plugs for my company, nothing. Partially because when I...

Please don't cross-post.

Original Post here: http://www.sqlservercentral.com/Forums/Topic1685618-3077-1.aspx

I'm curious - how is that script supposed to know what Report it's supposed to print?

ORDER BY <column name>

Add DESC at the end if you want to sort in descending order

That's correct, XML is case sensitive.

It's worth noting that you can improve you performance by adding a reference to the text node like so:

SELECT CBAADO = x.data.value('(cbaado/text())[1]','varchar(3)'),

...

I just finished this article and learned a few things. Well done.

See the link in my signature line for best practices on getting help then post DDL and sample data.

Prem-321257 (5/13/2015)

---

Thanks for the tips!

I changed the outer join to inner join and then using >= and <= operator instead of between. The execution time is now less then...

I don't know which column is your datecol but something like this:

WHERE <datecolumn> <= DATEADD(YEAR,-3,getdate())

We would also have to determine exactly what you mean by "three years old" e.g. leap...