Click here to Skip to main content
15,889,216 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: Login Control Woes Pin
Richard Blythe15-Dec-09 13:11
Richard Blythe15-Dec-09 13:11 
QuestionRegular expression for the time format 'HHMMAMPM' Pin
chandra vempati15-Dec-09 10:01
chandra vempati15-Dec-09 10:01 
QuestionTime Out Issue.....Javascript inside of an ASP.net application Pin
PDTUM15-Dec-09 9:10
PDTUM15-Dec-09 9:10 
AnswerRe: Time Out Issue.....Javascript inside of an ASP.net application Pin
Abhishek Sur15-Dec-09 9:32
professionalAbhishek Sur15-Dec-09 9:32 
QuestionAbout asp.net system slowdown Pin
leone15-Dec-09 6:06
leone15-Dec-09 6:06 
AnswerRe: About asp.net system slowdown Pin
Abhijit Jana15-Dec-09 6:22
professionalAbhijit Jana15-Dec-09 6:22 
AnswerRe: About asp.net system slowdown Pin
Abhishek Sur15-Dec-09 7:17
professionalAbhishek Sur15-Dec-09 7:17 
QuestionQuestion about writing a conditional SQL statement Pin
James Shao15-Dec-09 4:28
James Shao15-Dec-09 4:28 
I have a time series data in which a numerical indicator fluctuates over time. If I want to find out for which given day, this indicator has crossed above 30 in the past 3 days. Is it possible to write a SQL query that retrieve this information?

The logic to check for the crossing movement is:

IF indicator(day x) > 30 AND indicator(3 days ago from day x) <30 THEN
Return "YES WE HAVE AN UPWARD CROSSING MOVEMENT THROUGH 30 FOR PAST 3 DAYS!"
END IF

Can this be accomplished using a SQL CASE statement with a HAVING clause or something else?

I'd greatly appreciate any help! If possible please provide a sample code Poke tongue | ;-P

By the way I really want to thank you guys for helping me recently... Smile | :)
AnswerRe: Question about writing a conditional SQL statement [modified] Pin
dan!sh 15-Dec-09 5:00
professional dan!sh 15-Dec-09 5:00 
GeneralRe: Question about writing a conditional SQL statement Pin
James Shao15-Dec-09 12:43
James Shao15-Dec-09 12:43 
GeneralRe: Question about writing a conditional SQL statement Pin
James Shao15-Dec-09 15:50
James Shao15-Dec-09 15:50 
GeneralRe: Question about writing a conditional SQL statement Pin
dan!sh 15-Dec-09 17:06
professional dan!sh 15-Dec-09 17:06 
QuestionXPATH problem Pin
Rohit16db15-Dec-09 3:22
Rohit16db15-Dec-09 3:22 
AnswerRe: XPATH problem Pin
Abhishek Sur15-Dec-09 10:30
professionalAbhishek Sur15-Dec-09 10:30 
QuestionPage updating Pin
#realJSOP15-Dec-09 0:59
mve#realJSOP15-Dec-09 0:59 
AnswerRe: Page updating Pin
Eduard Keilholz15-Dec-09 1:08
Eduard Keilholz15-Dec-09 1:08 
GeneralRe: Page updating Pin
#realJSOP15-Dec-09 3:14
mve#realJSOP15-Dec-09 3:14 
AnswerRe: Page updating Pin
dan!sh 15-Dec-09 1:27
professional dan!sh 15-Dec-09 1:27 
GeneralRe: Page updating Pin
#realJSOP15-Dec-09 3:10
mve#realJSOP15-Dec-09 3:10 
GeneralRe: Page updating Pin
dan!sh 15-Dec-09 3:28
professional dan!sh 15-Dec-09 3:28 
GeneralRe: Page updating Pin
#realJSOP15-Dec-09 3:42
mve#realJSOP15-Dec-09 3:42 
GeneralRe: Page updating Pin
dan!sh 15-Dec-09 4:54
professional dan!sh 15-Dec-09 4:54 
GeneralRe: Page updating Pin
#realJSOP15-Dec-09 3:45
mve#realJSOP15-Dec-09 3:45 
GeneralRe: Page updating Pin
dan!sh 15-Dec-09 4:53
professional dan!sh 15-Dec-09 4:53 
GeneralRe: Page updating Pin
#realJSOP15-Dec-09 5:07
mve#realJSOP15-Dec-09 5:07 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.