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...

Fear...

Would it be possible to get a detailed explanation of what your are trying to accomplish here?

I'm a little confused. Perhaps if you could provide a picture of what you are talking about, as I have having a little difficulty seeing in my mind what...

Although posted in a SQL Server 2005 forum, I do have to give credit to the OP, he did state in his post he was using SQL Server 2000:

Hi all,

I...

Roy Ernest (2/19/2009)

---

Grant Fritchey (2/19/2009)

---

Roy Ernest (2/19/2009)

---

How fast can you run? 😀

If I was to be interviewed by you all, I would stand 25 meters away from you all so...