how to use conditional select query ? in sqlserver

Posted by Arunachalam on Stack Overflow See other posts from Stack Overflow or by Arunachalam
Published on 2010-04-13T05:14:04Z Indexed on 2010/04/13 5:22 UTC
Read the original article Hit count: 326

Filed under:

sqlserver2005

i have a column in which i store date type variable .now i should retrieve one value from that column and find the difference with the curent_timestamp and if the difference is less than 10 mins i should a return 1 and if more than 10 mins i should return 0.is it possible ?

05-12-2010 13.58.30 - 05-12-2010 13.56.30

here the difference is 2 so it should return 1 .

Related posts about sqlserver2005

SqlServer2005 Enterprise Fast Recovery, SqlAgent Availability, and Replication

as seen on Server Fault - Search for 'Server Fault'
I have a database under SqlServer2005 Enterprise 64bit sp3, that is in phase 3 of 3 of recovery after a reboot without normal shutdown. It looks like with fast Recovery, the database became available when recovery moved into phase 3. However, it seems (based on message in SqlAgent log), that SqlAgent… >>> More
"select * from table" vs "select colA,colB,etc from table" interesting behaviour in SqlServer2005

as seen on Stack Overflow - Search for 'Stack Overflow'
Apology for a lengthy post but I needed to post some code to illustrate the problem. Inspired by the question What is the reason not to use select * ? posted a few minutes ago, I decided to point out some observations of the select * behaviour that I noticed some time ago. So let's the code speak… >>> More
deleting records from multiple tables at a time with a single query in sqlserver2005

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi I wanna delete records from child tables as well as parent table with in a single query. please find the query given below. here response header is the primary table and responseid is the primary key. DELETE FROM responseheader FROM responseheader INNER JOIN responsepromotion ON responseheader… >>> More
My log file is so big, after truncate it 2 days, it still big like before

as seen on Server Fault - Search for 'Server Fault'
I'm using sql server 2005 and the log is too big 23 gbs (if you compare with the data file only 8GB). I've already run the truncate, after that the log file is 24mb but after 2 days, it becomes 23gbs. My database is full backup mode. I have the maintain plan is 2 hours will have diff backup and 24hours… >>> More
Facing problem in configuring Reporting Server

as seen on Server Fault - Search for 'Server Fault'
Dear All, I am unable to configure reporting server with sql server 2005 express edition. I have posted the link of a screen shot which shows the status.when ever i go to configure the reporting services it gives me the following errors(see screen shot)...also unable to start the reporting services… >>> More

Developer IT

how to use conditional select query ? in sqlserver - Developer IT

how to use conditional select query ? in sqlserver

sqlserver2005

Related posts about sqlserver2005

SqlServer2005 Enterprise Fast Recovery, SqlAgent Availability, and Replication

"select * from table" vs "select colA,colB,etc from table" interesting behaviour in SqlServer2005

deleting records from multiple tables at a time with a single query in sqlserver2005

My log file is so big, after truncate it 2 days, it still big like before

Facing problem in configuring Reporting Server

Categories cloud