Interested to Buy Any Domain ? << Click Here >> for more details...
Write an StoredProcedure to get the values of a column
within a date range.
- 1 Answers
- 6029 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / suren
Example:
select col1 from table_name where
(( convert(DateTime,Date_Column1,102) between coalesce
(@Date_Column1,convert(DateTime,Date_Column,102)) and
coalesce(@Date_Column2,convert(DateTime,Date_Column,102))))
//Date_Column: Column in the Table
//Date_Column1: first value of date range
//Date_Column12: second value of date range
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Example from .net. Integer & struct are value types or reference types in .net?
What does .net stand for?
Explain difference between panel and groupbox classes using .net?
Explain me what is the difference between an abstract class and an interface?
What is manifest in .net?
How is a managed code executed?
What is equivalent for regsvr32 exe in .net ?
How inheritance works in .net?
How ccw (com callable wrapper) and rcw (runtime callable wrappers) works?
can any one tel me the complete Testing Procedure of any one simple PROJECT i mean either web/windows based application?
What tools can I use to develop .net applications?
Explain the procedure to add assemly to gac to make it shared one?
What is lambda expressions in c#?
How com+ related to the dna architecture?
What is the base class of Button control in .NET?
