Dear SQL sharks....
Please somebody help me with this struggle. I have been searching the web for hours now.
I have a table with sales data. In this table i have a columne called SalesAmount, CustomerName and SalesDate(the format i smalldatetime)
Now I would like to retreive all the records where SalesDate is within current year...How do I do this??
I want to make a sum of this years sales numbers and when i pass newsyear it should start from zero again.
I really hope somebody can help me!!