WayneS (12/16/2010)

---

Using Kingston's fine sample code (hoanglong88i - please see the first link in my signature for how / why you need to do this), this seems to be producing...

Kingston Dhasian (12/16/2010)

---

This should do it for you

DECLARE@tblTemp TABLE

(

Patient_code int,

Patient_name varchar(50),

Invoice_code int,

Date_Visit date,

Date_Created date

)

INSERT @tblTemp

SELECT20, 'David', 2, '2010-11-15', '2010-12-15' UNION ALL

SELECT21, 'Anna', 3, '2010-12-15', '2010-12-15' UNION ALL

SELECT21, 'Anna', 4,...

Based on code from the other thread (provided by Kingston, with much thanks), try this:

DECLARE @tblTemp TABLE

(

Patient_Code int,

...

I'm not in a position to test, but don't you get the same issue when using decimal(19,4) as you do when usinf money?

Now I may be wrong, but I think...

Not sure how I'll do in the first round. Facing the Steelers again, last time we faced I lost.

WayneS (12/12/2010)

---

Tom.Thomson (12/12/2010)

---

Yes, it changes...

Chris Morris-439714 (12/8/2010)

---

Lynn Pettis (12/8/2010)

---

Chris Morris-439714 (12/8/2010)

---

Lynn Pettis (12/8/2010)

---

Chris Morris-439714 (12/8/2010)

---

Pah. That would waste the best part of four years which could be...

Chris Morris-439714 (12/8/2010)

---

Lynn Pettis (12/8/2010)

---

Chris Morris-439714 (12/8/2010)

---

Pah. That would waste the best part of four years which could be spent gaining full-time hands-on...

Four years? I...

Sorry to say but a Masters Degree isn't enough to become an Administrator. You need to actually can experience with these tools....

From your post I'm not too sure what the problem is or what you are expecting as results. Everything else we need to help is there.

GSquared (12/7/2010)

---

CirquedeSQLeil (12/6/2010)

---

Alvin Ramard (12/6/2010)

---

I won't forget the day a Linksys CS rep hung up on me after I told him he didn't have a clue about what he was...

GilaMonster (12/1/2010)

---

You know there's a problem when...

In the last 2 weeks there have been three resignations at current client:

The senior developer (leaving only 2 permanent developers)

The Chief Enterprise...

Steve Jones - SSC Editor (11/26/2010)

---

BTW, no idea what's happening in this thread, and not about to go through a few hundred posts over the last week. If there's something...

Jeff Moden (11/26/2010)

---

CirquedeSQLeil (11/26/2010)

---

da-zero (11/26/2010)

---

Hmmm. I found a post of Celko where he says that he is the way he is online because he uses the "tear them down to...