Now we have (almost) ready to use sample data.

"Almost" because I can't load the sample data "as is" due to a different DATEFORMAT setting, so you might consider in the...

Here's one version:

with cte as

(

select customer_name, max(order_date) as m_order_date, max(ship_date) as m_ship_date

FROM [order table]

GROUP BY customer_name

)

select customer_name

from cte

where m_order_date > m_ship_date

The QBW file stores the data in a specific way so that you'll need the original software to open it.

Using this software you could then export the data into Excel...

Remember that I can't look over your shoulder so I can't tell you what you might have done wrong.

Based on your very vague statement there's very little I can do....

Did you try to use the Debug mode in SSMS?

See my previous post:

...to move the data into separate tables and performa a UNION ALL query für...

Change the underlying query to return only the first x result sets (TOP x ORDER BY what_you_need).

One option would be to move the data into separate tables and performa a UNION ALL query für your reports.

You also might want to look into indexed filtered views if...

Since this is a dynamic query ("last 5 days" is causing a change in the column names) you'd need a dynamic CrossTab approach as described in the related article in...

how did you test the two options?

Using Management Studio and the table design wizard or a query window and the T-SQL command?

If the former (design wizard) then you should lok...

Here's an approach that would put you in the right direction syntactically.

LEFT JOIN dbo.test t (NOLOCK)

ON a.id = t.id

AND (C.parameter = @parameter OR C.parameter IS NULL)

AND a.rowid = CASE...

The tricky part is the namespace declaration xmlns="http://www.xyz.com".

This will force you to use the namespace within your query as well.

The followingcode shoud work:

;

WITH XMLNAMESPACES ('http://www.xyz.com' as ns)

SELECT t.c.value('(@triggerEvent)[1]', 'varchar(100)')

FROM...

ok, it's getting slightly more complicated:

WITH sample_cell AS

(

SELECT 'X' AS AxisCode, 1 AS Pos UNION ALL

SELECT 'Y' AS AxisCode, 1 AS Pos UNION ALL

SELECT 'Z' AS AxisCode, 1 AS Pos

),...

Did you try to run the excat code on the server in question?

My guess would be the code will also fai if run from the query window connected to the...

GilaMonster (11/14/2013)

---

LutzM (11/14/2013)

---

Just a pot shot:

It might be driven by the developer who want to make sure the key is unique but wasn't able to define a UNIQUE PRIMARY KEY...