hello,
im writing a stored procedure the will calculate the sales of the year from the startdate(1st jan 2008 to tilldate) .
can u assist to write a procedure?
Thanks
hello,
im writing a stored procedure the will calculate the sales of the year from the startdate(1st jan 2008 to tilldate) .
can u assist to write a procedure?
Thanks
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Vijaya KadiyalaPosted Jun 25, 2008, 2:05 PM
Hi
SELECT * FROM DateSample
WHERE DateVal BETWEEN '2008-01-01' AND '2008-06-31 23:59:59.997'
have the above statement inside stored procedude.
Thanks -- Vj
http://dotnetvj.blogspot.com
Scott LyslePosted May 9, 2008, 12:27 PM