Yes, that would be a partial solution, especially since 90-95% of columns are nullable..

Hi,

We checked TCP/IP settings in Configuration Manager and found out that TCP port for IP All was blank. Settings this to 1433 and using localhost instead of machine_name\instance_name...

Checked this, but it does not seem to be the...

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