To help those who will attempt to help you ... can / will you provide the table definition (or those fields pertinent to your question), some sample data and the...

Nice question for a Monday ... great start to the week

Might I suggest using the UPGRADE ADVISOR and carefully reviewing the results

upgrade advisor is available at;

http://www.microsoft.com/en-us/download/details.aspx?id=11455

Nice question on the basics ... thanks

NOTE Sean Lange's comments should / must be given every consideration...

although the following will do the task you require You might want to modify your T-SQL statement to:

...

ChrisM@Work (4/25/2013)

---

-- Always run a SELECT first to see which rows are affected.

-- This query should return the rows you want to keep

SELECT MemberId, [Event], [Event Date]

FROM (

SELECT MemberId, [Event],...

If I understand your question correctly... try this link

http://msdn.microsoft.com/en-us/library/ms175019(v=sql.105).aspx

This might be what you need.

SELECT CHARINDEX('SN',os,1) AS 'Starting position'

,CHARINDEX(';',os,CHARINDEX('SN',os,1)) AS 'Ending position'

,SUBSTRING(os,CHARINDEX('SN',os,1)+ 3 ,7) FROM #TempAD

Results:

Starting positionEnding position (No column...

Steve, thanks a great read particularly if one follows your link to

http://www.microsoft.com/en-us/news/stories/88acres/88-acres-how-microsoft-quietly-built-the-city-of-the-future-chapter-1.aspx

It has me wondering if someone will create software equal for our private homes ... and if...

Nice question - learned something from it ... Again thanks

+1

You can change the format for displaying the date using the convert function. For example:

SELECT id,CONVERT(VARCHAR(10), DateValue, 101)AS 'MM/DD/4...

Thanks - excellent information

todd.ayers (4/8/2013)

---

So this is what the user sees on the front end? This is the actual window they would be working in to retrieve information and so forth? It is...

Use this link to get a small (very small) image of SSMS

http://en.wikipedia.org/wiki/SQL_Server_Management_Studio