Please provide your table structure (table create script).

Lowell (9/28/2011)

---

Jim i think it's because you mixed up the order of the parameters.

,dateadd(m,datediff(m,0,dateadd(m,1,getdate())),+3) As Date_3

the "+3" in the above is a DATE...not the number of days to add. it's...

Try this instead

DECLARE @ThisDate DATETIME = GETDATE()

Select

@ThisDate As Date_1

,dateadd(m,datediff(m,0,dateadd(m,1,@ThisDate)),0)+3 As Date_3

,dateadd(m,datediff(m,0,dateadd(m,1,@ThisDate)),0)+2 As Date_4

,dateadd(m,datediff(m,0,dateadd(m,1,@ThisDate)),0)+1 As Date_5

,dateadd(m,datediff(m,0,dateadd(m,1,@ThisDate)),0) As Date_6

,dateadd(m,datediff(m,0,dateadd(m,1,@ThisDate)),0)-1 As Date_7

,dateadd(m,datediff(m,0,dateadd(m,1,@ThisDate)),0)-2 As Date_8

,dateadd(m,datediff(m,0,dateadd(m,1,@ThisDate)),0)-3 As Date_9

Yes - you can adapt this script to your actual table. However, you will still need the two subqueries inside that single select statement that has been provided.

Just change...

The only reason for that table variable was due to the need to create a testable script.

Try this updated script:

SELECT tabletext,RTRIM(LTRIM(Substring(deliveryText, start -1, length - start - fromEnd + 3))) AS [extracted]

FROM (

SELECT tabletext,MAX(PATINDEX([Matched], tableText)) AS start

...

Sean Lange (9/28/2011)

---

GSquared (9/28/2011)

---

select *

from dbo.MyTable

order by case Users when 'ALL' then 1 else 2 end, Users ;

That avoids even things like entries that begin with low-ASCII-value punctuation coming...

In SQL 2000, the recovery model is not displayed in the system catalogue like it is in 2005. However, thanks to the magic of functions you can retrieve it...

Cadavre (9/28/2011)

---

--Some test data first

DECLARE @TABLE AS TABLE (tableText VARCHAR(1000))

INSERT INTO @TABLE

SELECT 'Some Product Name Here 3.7mmD X 8mmL (SBM)

Product Code: 103708

<span style="color:red;">Availability: 9/26/2011</span>'

UNION ALL SELECT 'Some Product Name Here...

To capture the actual connection string you would need a packet capture.

To get all the relevant information for the connection, try querying sys.dm_exec_sessions

Is there another field in the database (such as PK) that would help in sorting this data in the desired way?

Is the schema frequently changing?

bcsims 90437 (9/28/2011)

---

But is it the train at the...

Daniel Bowlin (9/28/2011)

---

The light at the end of the...

GSquared (9/28/2011)

---

SQL Kiwi (9/28/2011)

---

WayneS (9/27/2011)

---

• DBA Certification preferred in SQL Server versions 2000, 2005, and 2008.

• ...