Instead of group by, you might think of OVER (PARTITION BY...)

These are what I use: the first script is for tables, the second one - for indexes:

WITH old_columns AS(SELECT t.name as table_name,

...

Denis,

Did you get any help with ISO-8859?

I need to export an XML in Spanish as well.

Kind regards!

If I do use MODE 64, than I get the HEXA characters list, f.e. 4797677535A4F6F4B6

If I try to convert it by using CAST(my_varbinary AS VARCHAR(XXX)) I get only ONE tag

I...

Sorry, was too excited... here is the message:

Msg 6830, Level 16, State 1, Line 3

FOR XML AUTO could not find the table owning the following column 'Synopsis' to create a...

Thank you for the link - I read it, but as I am newbie to this sing in Microsoft, didn't have a progress.

Hope there is another way to solve my...

Thank you for the reply,

The syntax I've typed here works for Oracle ( just changed the real names to the my_ ones ). Can you give me some more clues...

Here are she showplans.

The client a has a transaction log maintenance scheduled for each hour during the working times, so the log is very small - never goes over 50MB.

Regards,

Zeev

Thank you for the kind reply: the server has a scheduled transaction log maintenance set to each hour during the working hours, so I never saw it going over 50MB,...

Andras,

Thank you for the kind reply, but I think there is some misunderstanding: "First, your table you are inserting into has, in addition to the clustered index, seven nonclusterd indexes."...

OK,

Here it goes; it didn't let me to run the statement with 1,NULL,NULL as you suggested,

but NULL,NULL,'DETAILED' - hope it will be ok. I"ve loaded the result file here

SELECT *...

Andras,

Thank you for the kind reply - I will check this points.

BTW, I've bought the Query Prompt of Red Gate - nice product indead.

Zeev Kazhdan

Thank you for the reply.

I have a primary key on both tables and I have tried to play with WITH(INDEX()), but nothing changed.

There is no trigger nor constraint on both...