Because

All I want to put City and State information in front of Project

means for me that all the calculations should be done for the group of those three, in...

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...