Roy Ernest (2/19/2009)

---

Lynn Pettis (2/19/2009)

---

Grant Fritchey (2/19/2009)

---

Lynn Pettis (2/19/2009)

---

Put down the keyboard and back away slowly and noone will get hurt...

How do you think this OP would do in our...

Have you tried reading...

Is the application specific username passed back to SQL Server as part of the insert/update process?

Are these direct updates to the database, or done using stored procedures?

(Sorry if you already...

Please post the CREATE TABLE scripts for your tables.

Is this web-based or forms-based? In other words, does each user have a unique connection to the databasse or not.

ang_mora (2/19/2009)

---

I need to normalize this data making the member column the key:

MEMBER CLAIM #DateFrom DateTo Rank

1046241144232804/01/08 04/03/08 ...

Steve,

Back to your question about changes to SSC. Not sure, but someone else may have mentioned this, but knowing who started a thread in the Active Threads view would...

Depends. How is the data updated? If it is done using a stored procedure, the stored procedure should be modified to update those fields. If not, then...

Grant Fritchey (2/19/2009)

---

I'm going in....

GilaMonster (2/19/2009)

---

Be nice. He's new at this. (apparently)

Edit: Or maybe not. How have I managed to not notice this guy so far?

Alvin Ramard (2/19/2009)

---

Meanwhile, watch out for that SQL Biible...

Jack Corbett (2/19/2009)

---

Roy Ernest (2/19/2009)

---

He used to work in the white house? :crazy:

"I used to work at the White house in Washington DC, but I decide to change my career...

Put down the keyboard and back away slowly and noone will get hurt...

How do you think this OP would do in our mock interview?

This?

Select replace(CONVERT(nvarchar(30), GETDATE(), 6),' ','-')

How are you calling the stored procedures?

I'm still a bit over weight, like to loose about another 15 to 20 pounds. Not the fastest runner, but I do pretty good keeping up with most of...