Steve Jones - SSC Editor (4/12/2012)

---

SQLRNNR (4/12/2012)

---

Sean Lange (4/12/2012)

---

SQLRNNR (4/12/2012)

---

Steve Jones - SSC Editor (4/12/2012)

---

Both printers here are acting up. One doesn't want to inject ink on the the...

I am all for the concept of versioning. However, after reading through this, I find noone's addressed a few key issues that I have with traditional software versioning. ...

20 years ago, you saw something like that...

Wayne West (4/4/2012)

---

Backup/restore wouldn't work, I need real-time info and the DB is 100 gig. Failover isn't really an issue because of the application server. I don't need...

Up is the direction of the local friendly liquor establishment.

"You comin' to the bar later?"

"Yeah, I'm up to that."

Exact opposite, actually, but that's the point.

The other query...

I would agree. I...

peter 82125 (4/4/2012)

---

It should be, I agree with you. I really don't want to be rude, but we need to leave the political aspects of this out and focus on...

maheshkrishnas (4/5/2012)

---

hi all,

i have a 100 records in a flat file source , i need to send only the

first 97...

If it works and you understand it, roll with it. If you'd like further help and have code that does exactly what you need it to do, post it...

Mac1986 (4/4/2012)

---

I just wanted to figure out. which SPID is killing/Suspending the 100,77,70,71.

I see the query UPDATE [dbo].[WorkQueue]

SET WorkQueueStatus = 'DataLoaded'

WorkQueueStatusDate = GETDATE()

WorkQueueStatusUTCDate = GETUTCDATE()

WorkQueueEndWorkDate = GETDATE()

WorkQueueProcessingMSG = 'DataLoaded:...

aptlogix (4/4/2012)

---

S0001 - 2 - SOF-550

S0003 - 1 - SOF-550

S0004 - 1 - SOF-200 <-- This guy was PRESENT in the last lecture of SOF-550 but was absent...

Like so?

DECLARE @RunForDate DATETIME

--SET @RunForDate = '20120126'

SET @RunForDate = GETDATE()

;WITH LastPresent AS

(SELECT

StudentID,

MAX( Attendance_Date) AS MaxDate

FROM

@tblStudents

WHERE

Attendance = 'PRESENT'

AND Attendance_Date <= @RunForDate

GROUP BY

StudentID

)

SELECT

lp.StudentID,

COUNT(*) AS NumAbsents

FROM

LastPresent AS lp

JOIN

@tblStudents AS s

ONlp.StudentID = s.StudentID

WHERE

s.Attendance_Date...

GSquared (4/4/2012)

---

Evil Kraig F (4/4/2012)

---

Okay, I'm confused by the bolding of my name randomly in this post:

http://www.sqlservercentral.com/Forums/FindPost1278324.aspx

Is that supposed to mean something or am I just over-sensitive due to frustration...

Let me rephrase the question as to how I understand it and it might help.

Basically, what you're looking to do is take the existing list, re-order it by student, and...