mm (9/15/2009)

---

I tried your suggestion Drew and it's what I'm looking for!

Except... I'm getting a 'Incorrect syntax near 'END'.' I'm sure it's something dumb I'm overlooking.

-Michelle ...

Since you haven't posted DDL, sample data, and expected results, I can't test this. Try the following:

SELECT DISTINCT CRM_Orders.TRANSACTION_ID, CRM_StatusCodes.USER_STATUS, CRM_OrganizationalUnits.STEXT

FROM ...

Can you post your query? It helps to see what you have already done.

Drew

Depending on exactly what you are trying to accomplish, you might be better off using the WITH CUBE option. It will give you summaries for every possible combination of...

Since you failed to provide DDL, sample data, and expected results, I had to guess at what you wanted. I also had to use the AdventureWorks database.

The following code...

Make sure that the TableName = 'Sale' is in the ON clause and not in the WHERE clause.

Drew

You're welcome. It's nice to know that my Master's in Linguistics didn't totally go to waste.

Drew

It means 100,000. It comes from the same Indo-European root as lox. Since salmon weren't common...

lmu92 (9/6/2009)

---

create TABLE #t (start datetime, finish DATETIME,

CONSTRAINT [PK_t_start_finish]

PRIMARY KEY CLUSTERED (start, finish)

)

INSERT INTO #t

SELECT '11/08/2009 9:00:00 AM', '11/08/2009 10:00:00 PM' UNION ALL

SELECT '11/09/2009...

It's very easy to view your cube in Excel 2007.

From the Data ribbon, select "From Other Source" in the "Get External Data Section." (Alternatively you can use the Existing...

You have two options depending on what you need. Typically, I would just exclude these records from the original dataset in the first place. The other option is...

It doesn't matter which table you use as long as it has enough rows to give you the highest number that you want to allow. I simply used the...

Look up Order() in BOL. ...

When you select a datetime value in SQL Server, it outputs it in ANSI format. This allows the interface to select the appropriate format. If you really must...

Open your cube in BIDS and check the properties for that dimension. You want to make sure that the OrderBy property is set to Key rather than to Name.

You...