As Gail and Matt already pointed out, physical file fragmentation and index fragmentation are two different things.

Files are fragmented by definition on...

MySQL has no native physical backup tool to date.

That alone should keep you away from that crap.

On another note, Oracle bought the product just to kill it. If you don't...

Great!

Glad you solved your issue.

And, sorry if I have not been helpful enough.

The procedure does not run any query now, but it refreshes the view.

Right click the view and select "Script View AS... --> Create to... --> New Query Editor Window".

Has the...

kinderdesign (3/15/2012)

---

Here's the union on how these particular three are related:

SELECT FacilitiesList.Name

FROM FacilitiesList INNER JOIN

...

The procedure builds a dynamic SQL statement that UNIONs all the tables selecting all the columns that are present in all the tables.

You can see the statement being run adding...

Not complex at all.

5 tables? No problem: just add them inside the IN predicates:

... object_id IN (

...

The only way I can think of is a stored procedure with dynamic sql:

-- SETUP

CREATE TABLE TableA (

id int PRIMARY KEY CLUSTERED,

[1]...

Elliott Whitlow (3/14/2012)

---

I'm actually a little surprised they are making you change them on a production machine.. It is usually viewed as too risky and that new standards are...

Lynn Pettis (3/14/2012)

---

Amazing...

Back on topic, yes, they definitely are: http://www.sqlservercentral.com/Forums/FindPost1266924.aspx

????

Makes sense.

You would have to use dynamic SQL and perform a select distinct to make the column names dynamic in SQL.

Ah! Thanks Mr. Coffee!

I changed the column names because the OP wanted them with the '-' inside, but I forgot to change the code.

This should do:

SELECT *

FROM (

SELECT PartId,

value,

attribute...

This should do the trick:

SELECT *

FROM (

SELECT PartId,

value,

attribute = attribute + CAST( ROW_NUMBER() OVER(PARTITION BY PartId, attribute ORDER BY PartId, attribute) AS varchar(10))

FROM (

SELECT PartID,

value = COALESCE(CodeA, CodeB,...