Write an StoredProcedure to get the values of a column
within a date range.
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 method do you use to explicitly kill a users session? How?
Can you give an example of when it would be appropriate to use a web service as opposed to a non-serviced .NET component
What is Event - Delegate? clear syntax for writing a event delegate
What is the difference between asp.net and asp?
What is DTS and explain the purpose of it?
How to create multiple inheritance in c#, with example?
What is common type system (cts)?
What is COM Interoperability in .NET
What is the intermediate language between asp and asp.net1.0?
Tell us what do the following acronyms in .net stand for: il, cil, msil, cli and jit?
Different between .net & j2ee ?
Please explain what garbage collection is and how it works. Provide a code example of how you can enforce garbage collection in .net?
What is il in vb.net?
Explain me what is the .net framework and how does it work?
Tell us the difference between managed and unmanaged code?