Sean Lange (6/13/2013)

---

WayneS (6/13/2013)

---

dwain.c (6/12/2013)

---

I can only imagine what it must be like to have SQL Server running in some non-English language. MS probably translated the obtuse into the...

Stefan Krzywicki (6/13/2013)

---

There are two kinds of hyphens. The en hyphen which is the key on the keyboard and the em hyphen, which is longer and not on the keyboard....

SQLRNNR (6/12/2013)

---

Steve Jones - SSC Editor (6/12/2013)

---

jasona.work (6/12/2013)

---

I have to wonder how often Gail and the other pros here get frustrated with people asking questions where the answer is in...

I would say...

Sean Lange (6/5/2013)

---

dwain.c (6/4/2013)

---

I like Luis's first choice (to avoid the triangular join). Here's another:

SELECT cStudentID, iSchoolYearCode

,IsRepeat=CASE WHEN n<>iSchoolYearCode THEN 1 ELSE 0 END

FROM (

SELECT...

Thanks for the replies.

I have come to the awkward conclustion that the client has no DBA. I do believe they have some folks that are familiar with Windows domain...

andrew gothard (6/5/2013)

---

Brandie Tarvin (6/4/2013)

---

My Recovery Plan

1) SCREAM really loudly so everyone knows there is a problem.

2) Run out of the building as fast as possible.

3) Update my resume.

4) Job...

I was thinking more something like this:

With MySampleData([val])

AS

(

SELECT '1596424@DAR'

)

SELECT *,

LEFT(val,PATINDEX('%[^0-9]%', val)-1) as OneWay

FROM MySampleData;

Further poking around leads me to believe that the only accounts listed by the Config Mgr are Windows authenticated accounts, whereas 'myaccount' is a SQL authenticated account.

I'm wondering if it...

Wolf Kill - If you're still listening I need some further advice.

I was able to get the thing to work by changing this line in the SP:

,@useself='TRUE', @locallogin='myaccount';

To something like:

,@useself='FALSE',...

I like Luis's first choice (to avoid the triangular join). Here's another:

SELECT cStudentID, iSchoolYearCode

,IsRepeat=CASE WHEN n<>iSchoolYearCode THEN 1 ELSE 0 END

FROM (

SELECT *

...

What if the first non-numeric character in the string is not @?

Answer: You could use PATINDEX instead of CHARINDEX.

I agree! I just didn't see your suggestion before I posted mine.

ChrisM@Work (6/4/2013)

---

Kingston Dhasian (6/4/2013)

---

Wow. This is...

mickyT (6/3/2013)

---

dwain.c (6/3/2013)

Now if I can just figure out how to export that so I can keep in sync the various SQL servers I operate on, I'd be happy as...