Steve,

I am looking for ... from exactly 1 month ago through right now.

Thanks

i got it .. thank you

SELECT count(*) FROM table 
WHERE
  DATEOFPURCHASE >= DATEADD(MONTH, DATEDIFF(MONTH, 31, CURRENT_TIMESTAMP), 0)
  AND DATEOFPURCHASE < DATEADD(MONTH,...

sorry i mistaken 🙂

i want last onemonth data .

thanks for your reply steve.

here is the  query.

with
TABLEA
AS(
        SELECT A.* FROM dbo.TABLEA A with(nolock)
        JOIN dbo.TABLEC C with(nolock) ON C.ID...

Thanks a lot.

Thanks Sue.
Let me try it .

Sue, I dont think the process (Connect to SQL Server When Sys...) works because my windows account  wasn't added as sql login.

Thanks Sue.
No one have sysadmin access to the instance.

Thank you.. i am able to restore the sql2005 backup on sql2014 without any issues.

thank you !!