SQL Query

Jan 4 2013 1:53 AM

Hi Need Help

I have some data for particular month.

Now i want to display it datewise in that month.

Ex:suppose 20000 user register in month of july 2012, Now i want to display the no of user register on each day in month of july2012

Like 1) 500 2012-7-1
         2)489 2012-7-2
                  ....
                  ....
      31)45 2012-7-31

How sould i do this.

Answers (2)

Restrict user to select * from sys.tables,sys.databases ?

sql server