MarkusB (9/2/2009)

---

When you restore a backup of a database to a different server all string columns will keep the collation of the original database. In your case I suspect that...

Never mind.. Forgot the explicit outer select :w00t:

Yes, i understand the mechanism. I was wondering if it works for you as well with the data provided, since your initial reaction was that nothing was returned:-)

That is a bit scary, cause I want to make sure that it will work over at customers.

Would it be too much to ask to try my table download in...

It does exactly what I want ,when I specify the right languagecode.

The following is what I got at the moment:

select temp.id,temp.xmlname.value('(//Translations/Translation[@Language = "1043"])[1]','nvarchar(max)') from

(select id, cast(name as xml) as xmlname from someschema.sometable) temp

Still do not understand why the [1] is needed...

Ahum,

The xml expression itself is stored as a nvarchar(max) type and not as an xml datatype. I guess that means that the xml type of query expressions will not work?

The error received is returned through the BI-tool and is no more then a hint to contact the database administrator.

Tried to replicate the error message this morning , but...

scan table sysobjects for xtype = 'U' and table_name to avoid dropping other objects that may have the same name (accidently)

Sorry,

Must have been the lack of coffee.

I had @stamp defined as TIMESTAMP, if I define it as VARCHAR(23) then all is as should be..

No,

When I take the entire SQL string and run it, then the result is:

INSERT INTO [dbo].[H_DATUM_KEY] SELECT T.*,'Sep 16 2008 12:00AM' FROM [dbo].[V_H_I_DATUM_KEY] T

When I take your example the result...

Thanks Gary,

With batch I wasn't really thinking of running a command file, but really more of a solution on how to perform a similar action on a collection of tables.

I...

Yes, and thanks for putting all this effort into my post. I've yet to find some time to examine your extensive treatment, but I surely will !!

That is certainly true, the syntax has to be slightly different though as the alias has to be referenced first to make this work..

From my point of view the performance issue is secondary , since we're talking in the range of 5000 - 100000 records for a table. With SQL server 2005 and...