I have table name time_data in that it holds (docid,docdate,usertype,fromdate,todate,userid ) columns date format is 'dd/mm/yyyy' now i want to retrieve the data by giving the run time parameters month and year ...'JUN' and '2013' ..... for suppose if i give month jan and year 2013 in that jan month it what date i have entered ..has to come ...total sum of users..how to write a query for this.
asked Jun 21, 2013 at 08:25 AM in Default
In SQL Server / T-SQL, you could do something like:
(Untested, written without the aid of caffeine, probably woefully inefficient...)
answered Jun 22, 2013 at 07:11 PM