Very Computer

by **philip** » Tue, 11 Mar 2003 23:38:52

I have a query that will display data based on a
particular month chosen by the end user from a combo box.
My query does not return the correct data when the user
selects January it also returns October, November and
December. I also tried using the "m" instead of "mm" in
the datepart function. Below is my query. Any help is
appreciated.

PhilipL

AS

SELECT DailySalesTotal,Location,StoreName
FROM dbo.Sales

+ '%'

+'%'
ORDER BY DailySalesTotal DESC

by **Uri Diman** » Tue, 11 Mar 2003 23:45:59

Philip
Please post DDL and some INSERT's data that people don't have to guess.
What is expected result?

> I have a query that will display data based on a
> particular month chosen by the end user from a combo box.
> My query does not return the correct data when the user
> selects January it also returns October, November and
> December. I also tried using the "m" instead of "mm" in
> the datepart function. Below is my query. Any help is
> appreciated.

> PhilipL

> CREATE PROCEDURE [SalesData_Get]

> AS

> SELECT DailySalesTotal,Location,StoreName
> FROM dbo.Sales

> + '%'

> +'%'
> ORDER BY DailySalesTotal DESC

by **Rob Williscrof** » Tue, 11 Mar 2003 23:55:16

> I have a query that will display data based on a
> particular month chosen by the end user from a combo box.
> My query does not return the correct data when the user
> selects January it also returns October, November and
> December. I also tried using the "m" instead of "mm" in
> the datepart function. Below is my query. Any help is
> appreciated.

> PhilipL

> CREATE PROCEDURE [SalesData_Get]

> AS

> SELECT DailySalesTotal,Location,StoreName
> FROM dbo.Sales

> + '%'

> +'%'
> ORDER BY DailySalesTotal DESC

All of (1, 10, 11, 12) are LIKE '1%'

try:

HTH

Rob.

by **Philip** » Wed, 12 Mar 2003 05:28:30

Quote:>All of (1, 10, 11, 12) are LIKE '1%'

>try:

> AND CAST(DATEPART(mm,DailySalesTotal) AS

Quote:
>HTH

>Rob.
>.

Thanks for your response but I have a combo box that
displays all the months "January, February, ...and <all> "
(13 items in the combo box). So I need the LIKE clause to
trap the "<all>" if the user selects "<all>" then data for
the year will be displayed and if they select a month only
that month`s data
etc.

PhilpL

by **Tom Morea** » Wed, 12 Mar 2003 05:36:14

Really, you should have the front end make the decision to call one stored proc for the <all> case and another stored proc for an individual month. You'd be getting better performance, since each proc would be optimized for the individual query.

--
Tom

---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional

www.pinnaclepublishing.com/sql

>All of (1, 10, 11, 12) are LIKE '1%'
>
>try:
>
> AND CAST(DATEPART(mm,DailySalesTotal) AS

>
>
>HTH
>
>Rob.
>.
>

Thanks for your response but I have a combo box that
displays all the months "January, February, ...and <all> "
(13 items in the combo box). So I need the LIKE clause to
trap the "<all>" if the user selects "<all>" then data for
the year will be displayed and if they select a month only
that month`s data
etc.

PhilpL

Very Computer

SQL query - datepart ?

SQL query - datepart ?

SQL query - datepart ?

SQL query - datepart ?

SQL query - datepart ?

SQL query - datepart ?