Comments by Sara Dark

Sara Dark 28-Dec-11 2:00am View

i liked your solution more :)

Sara Dark 18-Dec-11 8:22am View

thank you

Sara Dark 16-Dec-11 8:21am View

create a table with field that references the id of the name and a field to put the keyword in and and id field and do your search using inner join

Sara Dark 15-Dec-11 7:59am View

thank you your answer was enough i know the difference now :)

Sara Dark 15-Dec-11 7:53am View

please can u explain briefly y "WHERE DATEDIFF ( MONTH , Invoice.DateOrderPlaced , GETDATE() ) > 3" wasn't added in the query with having
HAVING (SUM(Invoice.TotalPrice) > 20000 AND DATEDIFF ( MONTH , Invoice.DateOrderPlaced , GETDATE() ) > 3).
Im no expert i just want to know what difference does it make?

Comments by Sara Dark (Top 5 by date)