I am having problems with a alias.

Can someone shed some light on this for me?

SELECT ticket.tn, ticket.id, ticket_history.ticket_id, ticket_history.state_id, ticket_history.create_time, MONTH( ticket_history.create_time ) , YEAR( ticket_history.create_time )

FROM `ticket`

INNER...

This code works except for the DISTINCT. Please note from earlier posts this is MYSQL.

Also how can I create a create to run for every month to get a...

The first two work but they just return the column header.

Somehow we are not selecting(*) in the first line of the statement.

Many many thanks for your efforts so far.

This is...

Thanks for the reply.

The data types of the column are DATETIME in the format mm/dd/yyy hh:mm:ss and I am using the Date Picker in Report Builder 3.0 for...

OK I tried this again:

Select create_time

From ticket_history

WHERE create_time = @BeginningDate

and it just returns the column name and no values

Thanks for the prompt reply.

I tried this:

Select create_time,

From ticket_history

WHERE create_time = @BeginningDate

And I got this error message:

TITLE: Microsoft SQL Server Report Builder

------------------------------

An error occurred while executing the query.

ERROR [42000] [MySQL][ODBC...

Hello Lowell,

OK now I added the table and collumn

SELECT

DP.Name [DPName],

SUM(CASE WHEN DWI.System_Title LIKE '%Accept%'

THEN 1...

OK now I have this:

SELECT

DP.Name [DPName],

SUM(CASE WHEN DWI.System_Title LIKE '%Accept%'

THEN 1

...

Hello G Squared,

I would still love to see some TSQL examples and I will post in the Analysis Services forum.

Thanks for your time.

I still hope to see your TSQL examples.

Best,

Kurt

Hello GSquared,

No, not yet.

How can I use a Date Format something similar to what I am working on now?

SELECT {[Measures].[Work Item Count]} on columns,

NON EMPTY LASTPERIODS(30, [Date].[Date].[Date].[Date].[Month].[Date].[Year].[Year].&[20111201]) on rows

FROM [Team...

Hello All,

I still need some help with this.

Any ideas?

Kurt

We could do away with the Max if needed.

I know that GetDate() returns todays date.

What do you recommend?

True story.

Let's try using the LastUpdatedDateTime.

Once I see your syntax that will help me figure the rest of it out.

I am also going to be looking at the Warehouse Cube.

Again...

I think you are correct it is just a column for audit purposes.

What else can I use?

Many thanks for your help. I need to get this going.

Yes it is called LastUpdatedDateTime and it is in both the DimIteration and DimWorkItem.