Write an StoredProcedure to get the values of a column
within a date range.
- 1 Answers
- 5249 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
What is managed code and managed data in .net?
If I am writing in a language like vb or c++, what are the procedures to be followed to support .net?
What is difference between .net and .net core?
Please explain what is the difference between odbc and ado?
What are the features of dot net?
How to create properties and methods using controls?
Please explain when should you use .net web forms over asp.net mvc?
which methos do you invoke on the dataadapter control to load your generated dataset with data?
What is singlecall activation mode used for in .net?
How you apply a theme in whole application in .Net?
Is .net 4.8 backwards compatible?
What is cyclomatic complexity and why is it important?
What are the new thee features of com+ services, which are not there in com (mts)?
What is garbage collection in .net? Explain the garbage collection process?
Interop Services?
