Did you check the SQL Server Logs, not the SQL Server Agent Logs.

Steve Jones - Editor (4/9/2009)

---

I got that right away, hmmm, what does that say about me?

My kids wanted to...

sward (4/9/2009)

---

Hi Again,

Ok, here it is, the sample code i gave you was a mini replication of what i need to do, the field names and stuff are diffrent but...

That was perfect!

RBarryYoung (4/8/2009)

---

Heh....

Depends what kind of test data you are looking to create.

cm62597 (4/8/2009)

---

Thanks for you help....I guess I was having trouble telling you guys what I really needed. I could see it in my mind but hard to convey in...

Quickly, TraceID 2 is the default trace. You should never have more than 5 files and they don't get very big. the other trace, I suspect, is a...

Mind readers we are not. If you needed the results of your query then that is what you should have told us up front instead of indicating that you...

This:

select SUBSTRING(Field1,PATINDEX('%[^0]%',Field1),10)

FROM (

SELECT '05380101010000' AS Field1 UNION ALL

SELECT '05380101020000' UNION ALL

SELECT '05380101101000' UNION ALL

SELECT '05380011103000'

) TestData

does not return the result set you indicated you required.

In addition, not all MVP's are equal. We have seen solutions from MVP's that were not the best, and were actually of questionable value. It should be up...

Just checking, but did you also restart SQL Server?

Not only that, but that is what I thought was needed from the start, but I got confused by the subsequent posts until I had the OP show what was...

Try this:

select reverse(cast(cast(reverse(substring(col1,8,4)) as int) as varchar(4)))

I'm confused. Hightlight (BOLD) the values you are trying to extract:

05380101010000

05380101020000

05380101101000

05380011103000