SQL Help

Results 1 to 2 of 2

Thread: SQL Help

  1. #1
    Join Date
    Dec 1969

    Default SQL Help

    Hi Gurus,<BR><BR>I am not sure, Please let me guide how can I past month of getdate in heading. Like<BR><BR>March<BR>-----<BR>20<BR><BR>I am using following select but its not working.<BR><BR>Select Count(*) DateName(Month,GetDate())<BR>From sales

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL Help

    You cannot do it unless you do it like this in ASP<BR><BR>Select Count(*) as &#039;" & monthName(Month(date())) & "&#039; From Sales

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts