SQL SERVER (not reporting)
I need to store the results of a query, into a declaration, not actually run it.
@mydate = select top1 somdatefield from sometable
How do I store the result of the query into @mydate, in date format?
What I have found so far only executes the query in varchar format and doesn't store it.