User Profile

Collapse

Profile Sidebar

Collapse
RISHA
RISHA
Last Activity: Jul 31 '08, 02:18 PM
Joined: Jul 25 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • RISHA
    replied to count the rows
    in SQL Server
    i have to i have data in my table.i need to count the open issues for today ,30 days back,90 days back,180 days back.

    i wrote a stored procedure
    select projectname,cou nt('x') as "today's count",(select count('x') from table1 where(datediff( day,date_submit ted.getdate())> =30) group by projectname)as "30 days back count",(select. ......).

    when i write stored procedure like this i get a error...
    See more | Go to post

      Leave a comment:

    • RISHA
      started a topic count the rows
      in SQL Server

      count the rows

      can someone please help me.i wanted to count the rows of a table for today,30 days back,90 days back and 180 days back.can someone please help me to write a code for this in sql.thanks
      See more | Go to post
      No activity results to display
      Show More
      Working...