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

ASP.NET

 
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 
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 
This question will be best suited in the General database forum. Please make sure to post in correct forum from now on.
Just saw you have posted it there as well. Do not cross post. It is considered rude.

Assuming, your database fields are called indicator and date, try this:

select indicator from yourTable where indicator > 30 and datediff(date, getdate(),date) <= 3

if(@@rowcount > 0)
select 1
select 0

(not sure about order of getdate and date in datediff, you can check that through the query though)

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

modified on Tuesday, December 15, 2009 11:08 AM

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 
GeneralRe: Page updating Pin
dan!sh 15-Dec-09 5:14
professional dan!sh 15-Dec-09 5:14 

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.