SQLSat helped me answer this one.

James Stover (3/28/2012)

---

Lynn Pettis (3/28/2012)

---

James Stover (3/28/2012)

---

Lynn Pettis (3/28/2012)

---

James Stover (3/28/2012)

---

Computer science isn't dead, but the way it's taught probably is. By the time you finish a four-year degree in...

How about the following:

select

case when CHARINDEX('-',OrderNum) > 0

then OrderNum

...

Unfortunately tangents like this occur at times on the...

James Stover (3/28/2012)

---

Lynn Pettis (3/28/2012)

---

James Stover (3/28/2012)

---

Computer science isn't dead, but the way it's taught probably is. By the time you finish a four-year degree in CompSci, much of what...

Yep, missed it.

dwain.c (3/28/2012)

---

Interesting... Milliseconds bombs out on the same arithmetic overflow (which is useless anyway).

I guess there are too many seconds since the base date.

Fortunately minutes still works at...

gyoung 93471 (3/28/2012)

---

Paul Berzukov,

Thank you again for your helpful responses (and sorry it took me awhile to get back). I can see it's going to take me some time...

James Stover (3/28/2012)

---

Computer science isn't dead, but the way it's taught probably is. By the time you finish a four-year degree in CompSci, much of what you learned at the...

dwain.c (3/28/2012)

---

Lynn:

Just a slight change to the code shown here.

To make it work with seconds, however, you need a more recent date as using the "zero" date of 1900-01-01 results...

samg.j23 (3/28/2012)

---

For question 5, ......i am doing something wrong and i cant figure it out...it gives me null(blank Values)...is my mapping wrong or my queries...i am just starting...

Munabhai (3/28/2012)

---

No I donot have any cluster or pirmary or unique key in table, but as Antares686 said

select EmailAddress FROM omar.dbo.a123 where EmailAddress like...

opc.three (3/28/2012)

---

I agree with everything that's been said so far in terms of using NT Groups instead of SQL Logins. One item that was not explicitly addressed that you mentioned...

Just because I need to know, will that be part building the sql in the application or do you think you might start moving to using stored procedures to handle...

eshulman (3/28/2012)

---

Well, we know the insert has failed because we go to read the just inserted record and it is NOT there and we have an IDENTITY hole in the...