asking for SQL query

i am developing a account statement so when the user click on the link to view the February link it will show the transaction from Jan - Feb ,
how to format it to a query
i have the sample fo the following table:

ID trans_desc trans_date
-------------
1 testing 1/9/2003 11:33:00 AM
2 testing1 2/9/2003 11:33:00 AM
3 testing2 1/9/2004 11:33:00 AM

how to i extract the transaction description month from the month Jan-Feb . how to i do for the SQL queryIf there are 50 people on this forum, you'll get 50 different ways to do this. Here is one:

declare @.SelectedDate datetime
set @.SelectedDate = '2003-02-15'

select *
from YourTable
where trans_date >= convert(char(4), @.SelectedDate, 120)+'-01-01'
and trans_date < dateadd(month, 1, convert(char(7), @.SelectedDate, 120)+'-01')

AS2K5. Linked Measure Group. Why schould I include all measures?

If I Link a measure group I can don't include all measures. The Visual Studo notify no error either during editing or during deploiment. But during processing I get fully unqulified error message such as following

Errors in the OLAP storage engine: The metadata for the statically linked measure group, with the name of 'Verkauf', cannot be verified against the source object.

What a behaviour? Is this by design?

This doesnt look like by design behavior. Sounds more like a defect in the product.
Please go ahead and file it using feedback site: http://connect.microsoft.com/SQLServer/feedback/

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi Edward.

The feedback site is a mess. There is not filtering by category (SSAS). I schoul use full text search.