Yes I have grouped it on date entered and company name and I tried what you suggested and still the same result.

Sure I have attached it. This one looks ok but sometimes it gives me wrong value in between.

241,174

17,433

118,157

14,077

12,295

2,866

In sql I am using

Order By DateEntered,...

It gives me values like these

241174

17433

118157

14077

12295

2866

739

Thanks Alvin Ramard, I changed the query convert for date.

The issue is with date sort order. it sorts it in lower number first then higher date it is a weekly report but when the month change and if I...

syedathariqbal (6/3/2015)

---

Hi Ven,

Were you able to solve your issue? I am not able to understand clearly what exactly your issue was?

Is it that if you enter - 'Ind' in your...

Thanks I would try your suggestion and get back to you.

Thanks for all your help I would try to work something out.

Sorry I did cut and paste I ran your query again without having and it runs it but It does give me the desired result where company is listed only...

when I ran the below query

I got this error

Msg 8121, Level 16, State 1, Line 12

Column 'SalesOrder.DateEntered' is invalid in the HAVING clause because it is not contained in either...

Is there a way to fix this query?

Thanks,

Hi

I am very new to SQL and appreciate your help.

I am not sure about code but here is the query

Msg 8120, Level 16, State 1, Line 1

Column 'Company.CompanyName' is...

When I try to use group by company name or account number then I get the error

Column 'Company.CompanyName' is invalid in the select list because it is not contained in...

Lynn,

I am sorry I posted wrongly. I have got the answer from here

http://www.sqlservercentral.com/Forums/Topic1318719-1291-1.aspx and it has helped me to get the result what I was looking for.

Thanks,