Click here to Skip to main content
15,867,686 members
Home / Discussions / Database
   

Database

 
GeneralRe: sql Pin
Gerben Jongerius3-Nov-10 21:39
Gerben Jongerius3-Nov-10 21:39 
GeneralRe: sql Pin
RaviRanjanKr4-Nov-10 8:19
professionalRaviRanjanKr4-Nov-10 8:19 
AnswerRe: sql Pin
RaviRanjanKr16-Dec-10 3:46
professionalRaviRanjanKr16-Dec-10 3:46 
QuestionMigrating from Oracle to SQL Pin
Arudya2-Nov-10 19:57
Arudya2-Nov-10 19:57 
AnswerRe: Migrating from Oracle to SQL Pin
jschell4-Nov-10 8:57
jschell4-Nov-10 8:57 
QuestionDatetime format checking in SQL server stored procedure Pin
Danpeking2-Nov-10 4:54
Danpeking2-Nov-10 4:54 
AnswerRe: Datetime format checking in SQL server stored procedure Pin
David Skelly2-Nov-10 7:18
David Skelly2-Nov-10 7:18 
GeneralRe: Datetime format checking in SQL server stored procedure Pin
Danpeking3-Nov-10 5:52
Danpeking3-Nov-10 5:52 
Hi David, the parameter will be a datetime. I need to find which date range this falls in.

For example, I pass in the date 11/11/2010 and the columns are:

ID StartEffDate EndEffDate Rate
1 01/01/2000 31/12/2003 1.05
2 01/01/2004 31/03/2011 1.15
3 01/04/2011 01/01/2012 1.25

I need to return the appropriate Rate, e.g. in this case 1.15
AnswerRe: Datetime format checking in SQL server stored procedure Pin
Luc Pattyn2-Nov-10 7:46
sitebuilderLuc Pattyn2-Nov-10 7:46 
AnswerRe: Datetime format checking in SQL server stored procedure Pin
Jörgen Andersson2-Nov-10 22:45
professionalJörgen Andersson2-Nov-10 22:45 
QuestionHow to compare same field in two tables in sql server 2005 using C# Pin
cancerion2-Nov-10 4:02
cancerion2-Nov-10 4:02 
AnswerRe: How to compare same field in two tables in sql server 2005 using C# Pin
RaviRanjanKr2-Nov-10 4:36
professionalRaviRanjanKr2-Nov-10 4:36 
AnswerRe: How to compare same field in two tables in sql server 2005 using C# Pin
thatraja2-Nov-10 4:55
professionalthatraja2-Nov-10 4:55 
QuestionHow to add image to sql server database ? Pin
Yanshof1-Nov-10 23:37
Yanshof1-Nov-10 23:37 
AnswerRe: How to add image to sql server database ? Pin
Tony Pottier1-Nov-10 23:57
Tony Pottier1-Nov-10 23:57 
GeneralRe: How to add image to sql server database ? Pin
RaviRanjanKr2-Nov-10 4:48
professionalRaviRanjanKr2-Nov-10 4:48 
GeneralRe: How to add image to sql server database ? Pin
Jörgen Andersson2-Nov-10 22:09
professionalJörgen Andersson2-Nov-10 22:09 
AnswerRe: How to add image to sql server database ? Pin
RaviRanjanKr16-Dec-10 3:53
professionalRaviRanjanKr16-Dec-10 3:53 
Questioncan't restore differential backup and tracsaction log. Pin
tan8731-Nov-10 21:31
tan8731-Nov-10 21:31 
AnswerRe: can't restore differential backup and tracsaction log. Pin
Corporal Agarn2-Nov-10 4:47
professionalCorporal Agarn2-Nov-10 4:47 
QuestionEMS SQL for PostgreSQL Pin
Jassim Rahma1-Nov-10 21:10
Jassim Rahma1-Nov-10 21:10 
AnswerRe: EMS SQL for PostgreSQL Pin
TweakBird8-Nov-10 1:07
TweakBird8-Nov-10 1:07 
QuestionPostgreSQL code problem Pin
Jassim Rahma1-Nov-10 3:56
Jassim Rahma1-Nov-10 3:56 
AnswerRe: PostgreSQL code problem Pin
Chris Meech1-Nov-10 7:49
Chris Meech1-Nov-10 7:49 
Questiona column defination list is required for functions returning 'record' [modified] Pin
Jassim Rahma1-Nov-10 3:49
Jassim Rahma1-Nov-10 3:49 

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.