Stefan Krzywicki (10/17/2012)

---

dwain.c (10/17/2012)

---

Stefan Krzywicki (10/17/2012)

---

I really hate automatic reboots of desktops because of "security patches". If I come in and it tells me I need to reboot, fine. I...

Here's another way (just foolin' around):

;WITH MyData AS (

SELECT score=65.00 UNION ALL SELECT 108.00 UNION ALL SELECT 1108.00)

SELECT LEFT(REVERSE(CAST(REVERSE(score) AS DECIMAL(8,4))), 4)

FROM MyData

Jeff Moden (10/17/2012)

---

Sean Lange (10/17/2012)

---

Jeff Moden (10/16/2012)

---

Wow... recent interview of a Web Developer interviewee just set a new record. Interviewee claimed 14 years experience in SQL (mostly Oracle) and...

SQLRNNR (10/17/2012)

---

Jeff Moden (10/17/2012)

---

Sean Lange (10/17/2012)

---

Jeff Moden (10/16/2012)

---

Wow... recent interview of a Web Developer interviewee just set a new record. Interviewee claimed 14 years experience in SQL (mostly Oracle)...

Stefan Krzywicki (10/17/2012)

---

I really hate automatic reboots of desktops because of "security patches". If I come in and it tells me I need to reboot, fine. I can note everything...

To add my two cents, the English language is sometimes at best ambiguous, so problem descriptions in narrative are often unclear.

Most of the senior posters here are code-talkers - they...

ericb1 (10/17/2012)

---

Any help is greatly appreciated, I have 2 different SQL servers, and I need to syncronize some information about users in 1 system with users in another.

In system #1,...

Jeff Moden (10/17/2012)

---

Just my 2 cents on indexing. Be careful when using only indexing to "tune" a query especially on OLTP tables. I'm not suggesting that you should...

Cadavre (10/17/2012)

---

dwain.c (10/16/2012)

---

I recommend that you take heed of Jeff's question above. An improper JOIN often generates tons of duplicates and developers can be too lazy to understand why...

I...

L' Eomot Inversé (10/16/2012)

---

All these methods using [A-Za-z0-9] recognise 139 characters (with the Latin1_General_ci_as collation).

Now personally I think that's right (although it's a rather complicated pattern to use for...

:-P:-P I was going to say that! :hehe::hehe:

I recommend that you take heed of Jeff's question above. An improper JOIN often generates tons of duplicates and developers can be too lazy to understand why and eliminate...

Perhaps he was so focused on the future he's never interested in the temporal currency....

whenriksen (10/16/2012)

---

@dwain.c

Excellent, that is just what I needed.

After working with it for a bit this morning, I've determined I need to assign the groups string in a checksum...