keymoo - thanks for providing the excellent sample data, table definitions, and desired output. Without it, I think you'd still be waiting for a solution.

Chris Morris-439714 (9/8/2010)

---

WayneS (9/8/2010)

---

Here's my solution. I took a similar approach that Chris did to make a row for each unit, but how we did that is different (I'm using...

Here's my solution. I took a similar approach that Chris did to make a row for each unit, but how we did that is different (I'm using a tally table...

Something like:

CREATE TABLE Book (BookID int....)

CREATE TABLE Borrow (BookID int, ...)

INSERT INTO Book --...

GilaMonster (9/8/2010)

---

Shouldn't and no.

Recovery just needs the active portion of the log, the...

Richard,

Here's an example, using your provided code:

--Top select

SELECT ClientID,ReferralNumber,AppointmentDate,ActualTime

--,Count(*)

FROM dbo.vwBRSAppointmentsNPD

WHERE SpecialtyReferredTo='ICNR'

AND AppointmentContactCancellationDateTime IS NULL

AND AppointmentDate between...

Grant Fritchey (9/8/2010)

---

WayneS (9/7/2010)

---

Steve Jones - Editor (9/7/2010)

---

Actually I picture Lutz...

vrkn82 (9/8/2010)

---

How to update a total column with different values in a table. I want to insert a new column in a table and insert values from other table. How...

I'm speculating here... if the database was...

You're setting @Month = '20100801'

Then, in you're doing:

BASE.SERVICE_YR_MO BETWEEN CONVERT(CHAR(6),DATEADD(M,-24,CONVERT(datetime,@MONTH + '01',112)),112) AND @MONTH

AND

BASE.PAID_YR_MO BETWEEN CONVERT(CHAR(6),DATEADD(M,-15,CONVERT(datetime,@MONTH + '01',112)),112) AND @MONTH

Adding the string '01' to '20100801' gives you '2010080101', which is...

This looks okay - as long as you're doing it in the font color property?

Megistal (9/7/2010)

---

Using something like

CREATE TABLE tab1 (

ID INT Identity(1,1)

, Col1 int

)

INSERT INTO tab1

SELECT Col1 FROM tab2

Does it guaranteed me that new rows inserted in...

The...

Yes.

SQL Server 2008 Upgrade Technical Reference Guide

jcrawf02 (9/7/2010)

---

LutzM (9/7/2010)

---

Steve Jones - Editor (9/7/2010)

---

Actually I picture Lutz as...