Richard Warr (6/6/2011)

---

Mathematically we've seen how this can be "proved". But using pure logic we're essentially saying that a number that is definitely less than 1 is the same as...

GSquared (6/2/2011)

---

toddasd (6/2/2011)

---

GSquared, I think it would be a wonderful thing to sit at a bar and have some beers with you. We would probably spend the whole night debating...

This is the problem at hand for your colleagues. They are thinking 0.999... as a *process* instead of simply a...

"Why are we here?"

"To help others."

"Then what are the others here for?"

GSquared, I think it would be a wonderful thing to sit at a bar and have some beers with you. We would probably spend the whole night debating when a...

That brings up memories. 🙂 We had the same whiteboard discussion about 3 years ago at my old workplace. At that time, I was (ignorantly) on the against side. I...

Following from Lutz's suggestion, here is an example of a computed, persisted column:

create table Max_test(col1 int, col2 int, col3 int, col4 int,

max1 as

case when (col1 + col2) > (col2...

As JC would say, SQL has no CASE statement, it's...

Yep, yours is good too. It will all depend how you want to define a week.

--Lutz

SELECT COUNT(task_id) AS cnt,DATEPART(isowk,create_time) AS ISO_wk,YEAR(create_time) AS Yr

FROM Tasks

GROUP BY YEAR(create_time),DATEPART(isowk,create_time)

--Craig

SELECT Year, Month, Week, PeriodBegin,PERIODEND,...

There has been no criticism in this thread except for what you are reading into it. You first have to help yourself by helping us. Look at this post

If we look at just this first part:

IF Exists(

Select pt.intQuestionId

from tblPermTask pt

INNER JOIN tblsrpeventdata ed on ed.intquestionId = pt.intquestionid and ed.intpersonnelid = pt.strssn

where (intAnswer = 1 or intAnswer...

Post your trigger definition on End_Edu_Details and we can help you modify it to also update the date on Eng_Details.

I was playing with this problem for about an hour before reading the excellent observation by opc.three. I also like his pre-calculation in the cte above.

As another alternative, you could...

A friend (sql guru in his own right) helped me figure it out. In my example above, the SELECT 1/0 is returning a result before the error is thrown. It...

I actually did think about that 20 minutes after I posted and tried that change, but to no affect.