Write an StoredProcedure to get the values of a column
within a date range.
- 1 Answers
- 5620 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
Is .net a language?
How many namespaces are in .net version 1.1?
What is alias ? Is it used in .Net ?
How do you view the methods and members of a dll?
What is implement a generic action in webapi?
If we write any code for DataGrid methods, what is the access specifier used for that methods in the code behind file and why?
What is 'Common Type System' (CTS) in .NET?
What is operator overloading in .net?
Describe the Managed Execution Process?
How you apply a theme in whole application in .Net?
Explain different types of html, web and server controls.
What is difference between .net and .net core?
What are the difference bbetween value type & reference types ? Example from .net. Integer & struct are value types or reference types in .net?
How do you define the lease of the object in .net?
What is DTS and explain the purpose of it?
