I need a simple query written, where a query selects all records in a column for today's date, and returns the count of the number of records found.
My current code looks like this
SELECT
COUNT([login to view URL]) AS counted_orders
FROM [login to view URL]
WHERE SalesOrderDate = GETDATE()
GROUP BY [login to view URL]
The column SalesOrderDate is in format SmallDateTime and will need to be converted
Hello Sir /Ms,
What is the problem with the query?
Please talk to the chat for details
About me
I am a web developer focused on Microsoft technologies,
I worked about 4 years developing web applications built using Asp.net and SQL Server 2005, 2008 and 2012.
Hello Friend,
i am Software/Web Developer
My good points:
- Master Degree in Computer Science
- 4+ years of experience
- Professional developer
- Delivered before time
- My good habit is to leaving comment code.
- Prefer to maintain good relations
----
*let's discus before award project
---
Feel free to ask any query
Hi i hope i am not late to bid on this task,
Can you please give me a chance to make this query , i have expert in SQL. having 8 year development experience in sql.
i am Available .
Thanks,
Zeeshan
I can give it to you in 30mins. It is done by now. I used to make queries that summarizes daily production results that keeps on running daily at 7 am.
I could certainly program the sql query you require within time, budget and to your satisfaction. Please view my portfolio for similar projects and contact me for more details.