I guess your StudentAddress table is a link table between Address and Student tables, right?

If so, when you edit the link you better delete and insert "link" rows if they...

sqlfriends (3/19/2013)

---

Eugene Elutin (3/19/2013)

---

sqlfriends (3/19/2013)

---

...when creating tables, shall I just use the plain names, like Address instead of addrAddress, StudentHomeAddress instead of addrStudentHomeAddress?

Also for domain tables shall I just: City,...

raym85 (3/19/2013)

---

I must admit the guy who wrote the query qith the XML logic was an eye opener for me, I reallyed liked that method best. The way I have...

sqlfriends (3/19/2013)

---

...when creating tables, shall I just use the plain names, like Address instead of addrAddress, StudentHomeAddress instead of addrStudentHomeAddress?

Also for domain tables shall I just: City, County instead of...

Yes it can. Just use CAST function.

My last post...

Yep, I know,...

Most of OP output results do not match relevant formulas, eg:

B/A 3/19/2013= 7/ 2 = 3.5 not 0.285714286!

Any way thank's to Lowell for data setup:

declare @MySampleData table (Date datetime, Name...

Even shorter version:

CREATE PROCEDURE [dbo].[GetExtractSiteExtractFileBatchPreviousSuccessInd]

@BatchStatusCd NVARCHAR(5)

,@ExtractSiteCd NVARCHAR(10)

,@ExtractAsOfDate DATETIME

AS

SELECT MIN(Res) AS ExtractSiteExtractFileBatchPreviousSuccessInd

FROM

(

SELECT 1 AS Res

UNION...

Ough, I can see now!

You need to learn and use proper terminology!

The stored procedure you have does return an integer value (as I've pointed out in the previous post...

What do you mean it returns no VALUE?

Regardless of what you have in stored proc it always return a value! By...

kl25 (3/19/2013)

---

Agreed. 🙂 My query just presents the results in the format the OP listed at...

Are you sure that OP wants one column with all subjects concatenated?

If not, then he might want dynamic cross-tab:

SELECT dow.[DAY], s.[Subject], ROW_NUMBER() OVER (PARTITION BY dow.[DAY] ORDER BY...

jbalbo (3/19/2013)

---

Hi

I am getting a syntax error on the following:

case

DATEPART(mm,APPT_RPT_APPOINTMENT.START_DATETIME)

when 07

then (APPT_RPT_APPOINTMENT.DURATION / 60)

end...

Do you have CDC enabled for this table?