nonstandard ...

      In context .. the modeling is correct (or the default, at least I think so, sorry...;-)):

create table #students

(id int identity (1,1)...

Jeff Moden (3/21/2013)

---

carlosaamaral (3/21/2013)

---

Sean Lange (3/21/2013)

---

carlosaamaral (3/21/2013)

---

Logic ?

MID=(CASE WHEN ID-100=0 THEN NULL

...

Sean Lange (3/21/2013)

---

carlosaamaral (3/21/2013)

---

Logic ?

MID=(CASE WHEN ID-100=0 THEN NULL

...

Logic ?

MID=(CASE WHEN ID-100=0 THEN NULL

...

Thank you....

OPS... living and learning ....

   changed to level 100 - perfect ..

; WITH THE Strings (

SELECT String = 'AJKY.GSEFD6, 7345535HNB, BBN4343.434'

UNION ALL SELECT '11-908 / *** 88AB; '

)

SELECT

s.String,

x.NewString

FROM Strings s

CROSS...

Hello Chris,

   Sorry - I may be doing something wrong ...

  

Message 102, Level 15, State 1, Line 11

Incorrect syntax near '.'.

;WITH Strings AS (

SELECT String = 'AJKY.GSEFD6,7345535HNB,BBN4343.434'

UNION ALL SELECT...

Good Morning,

to 200,000 lines is very, very slow ..... :crying:

    to 1 line, it's good ...

I will continue using the replace...

FANTASTIC :w00t: ...

    responding very quickly ..

     THANK YOU

Aberration *= e (+)(Oracle), terrible ... *= Dead in SQL2012.....

has happened in a database 2005 (left outer join urgent!) 😀

SELECT 'Group Name'=AA.NAME,

'Type 1'= (CASE WHEN (SELECT TOP 1 name FROM #GroupTypes BB WHERE BB.grouptype_id=AA.grouptype_id)='Type 1' THEN 'X' ELSE '-' END),

...

Correction: this is my solution ... Eugene, did not like the use of non-ansi join... After.. Everything started ... 😀

...

Logic ???? :w00t:

DECLARE @T TABLE(ID INT,NAME VARCHAR(10))

INSERT INTO @T VALUES(1,'PPP')

INSERT INTO @T VALUES(2,'AAA')

INSERT INTO @T VALUES(2,'ZZZ')

INSERT INTO @T VALUES(3,'XYZ')

INSERT INTO @T VALUES(4,'PQR')

INSERT INTO @T VALUES(5,'ZAB')

DECLARE @T_INPUT TABLE(ID int...

Hi,

is correct XML file?

in some cases the tags were not closed: <Node... /> or <Node...> </ Node> ...

DECLARE @idoc...

(CASE WHEN (CHARINDEX('M',Position)!=0 And CHARINDEX('D',Position)!=0) THEN 'MD'

ELSE POSITION -- ??

END) PositionCorrected

...