Viewing 15 posts - 226 through 240 (of 345 total)
GSquared (6/2/2011)
toddasd (6/2/2011)
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
June 3, 2011 at 8:33 am
calvo (6/3/2011)
...-".999 repeating will never equal 1, it's always .000...1 short"
This is the problem at hand for your colleagues. They are thinking 0.999... as a *process* instead of simply a...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
June 3, 2011 at 7:49 am
"Why are we here?"
"To help others."
"Then what are the others here for?"
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
June 2, 2011 at 2:04 pm
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...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
June 2, 2011 at 12:22 pm
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...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
June 2, 2011 at 10:23 am
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...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
June 2, 2011 at 7:32 am
abhisheksrivastava85 (6/2/2011)
... I cannot use case statement as table is already bulky and it will make my query more expensive ...
As JC would say, SQL has no CASE statement, it's...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
June 2, 2011 at 7:16 am
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,...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
June 1, 2011 at 12:36 pm
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 http://www.sqlservercentral.com/Forums/Topic1116896-392-1.aspx...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
June 1, 2011 at 9:54 am
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...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
May 31, 2011 at 3:34 pm
Post your trigger definition on End_Edu_Details and we can help you modify it to also update the date on Eng_Details.
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
May 27, 2011 at 10:04 am
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...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
May 24, 2011 at 3:44 pm
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...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
May 24, 2011 at 8:43 am
I actually did think about that 20 minutes after I posted and tried that change, but to no affect.
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
May 23, 2011 at 6:56 pm
SELECT * FROM INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
May 19, 2011 at 8:37 am
Viewing 15 posts - 226 through 240 (of 345 total)