ALTER FUNCTION [dbo].[StrBetween] (@InputStr varchar(MAX), @StrStart Varchar(255), @StrStop Varchar(255))

RETURNS VARCHAR(MAX)

AS

BEGIN

DECLARE @STR VARCHAR(MAX),

@START...

Chris, I see what you mean.

I'm not sure it works because the key word in my last post was usually. 🙂

There can always be more than 4 pairs for the...

Yes, for the same ID there can be multiple pairs of old value/new value.

As for the maximum number of pairs, ... usually there are 3 or 4 pairs.

My first choice would be to create an UDF (I use S2K5) which returns a string with the first n group names, given an ID

CREATE FUNCTION dbo.FirstNGroups (@ID INT, @N...

Throwing myself in the lions pit :), I would write something like this

ALTER PROCEDURE [dbo].[Search]

@user-id nvarchar(10),

@TicketID int,

@Type nvarchar(80),

@Priority nvarchar(20),

@FromDate datetime,

@ToDate datetime

AS

BEGIN

SELECT TicketID, UserID, Title, Status, Type, Priority, CreationDate

FROM...

I'm guessing that your query is wrong. This is the first assignment to SQLUpdateQuery

SQLUpdateQuery = "UPDATE CALENDAR SET CalendarDate = '"...

As I said in P.S., not all tables have an IDENTITY column.

And I don't have an Insert Procedure.

I think that you can limit the initial rows you get in the CTE if you order the query and use the TOP clause

;WITH emp AS (SELECT TOP (@PageNumber *...

Actually, LEN excludes the 14 trailing blanks in the word.