In that case, presumably we would search first for a digit only, "%0-9%", then do the search...

SELECT Fulltext, Contract2,

Substring(Contract2, Contract3_Start, Contract3_Length) AS Contract3

FROM (

SELECT Fulltext From [Sonae].[dbo].[Images_Local]

) AS test_data

cross apply (

SELECT Substring(FullText, PATINDEX('%Contrato%',FullText), 50) as Contract2

) as...

SELECT Fulltext, Contract2,

Substring(Contract2, Contract3_Start, Contract3_Length) AS Contract3

FROM (

SELECT 'Contrato Promocional 2010-241772 Descrico CDR TD' AS Fulltext UNION ALL

...

CELKO (10/10/2014)

---

No it is not; we have the ANSI/ISO Standard CREATE SEQUENCE now....

CELKO (10/10/2014)

...

CELKO (10/10/2014)

Finally, we use lowercase for data types, because in SQL Server type names are case sensitive in many contexts. We do not want to cause unexpected future errors...

CELKO (10/9/2014)

A competent professional in any trade would do it right without any special effort. Does a doctor think about stitches, or does he just do them? He would also...

CELKO (10/9/2014)

1. You have many ISO-11179 violations. Do you have only one Employee, as you said? The correct name is “Personnel”; an abstract set of elements.

2. A procedure is...

Yes, plenty of people have investigated and written on this. ...

lawson2305 (10/8/2014)

---

ok found the offending EXE causing this issue but I have some questions on the tempdb. This will have to be looked at why this is happening by...

joepacelli (10/8/2014)

---

The outputrowcount is fine. It returns 1

it's my identity column which is returning 0

I also tried Ident_current('dbo.jobid')

This returns the correct value

But, according to MSDN site

Be cautious about using IDENT_CURRENT...

Luis Cazares (10/8/2014)

---

ScottPletcher (10/8/2014)

---

Hmm, seems to be that code would list the same customer, the "first" one, over and over rather than listing every individual customer in the state. ...

Eirikur Eiriksson (10/3/2014)

---

The following is wrong

datediff(day, convert(varchar,MANUFACTUREDDATE, 101),convert(varchar,getdate(), 103))

,it is comparing MM/DD/YYYY to DD/MM/YYYY, the only thing the convert does in the query is setting the format of the output...

@@ROWCOUNT must be captured immediately after the SQL statement or its value gets reset.

However, since you've added an OUTPUT clause, you can get the number of rows affected form that...

Hmm, seems to be that code would list the same customer, the "first" one, over and over rather than listing every individual customer in the state. Are you actually...