I used sp_executesql with openrowset to put the result into a global tmp table thou it creates a column name with XML_xxx_xxxxx_xxx etc.

I can't figure out how I can insret...

I was looking something where I do not have to parse procedure text.

I believe that SQL Server has it saved somewhere in the system tables, thou so far I haven't...

If your databases are identical just back up the database on the data source server, and restore the database on the target server.

It should take about 5 minutes to move...

IF you use dts you should set the option

to copy indexes.

If you backup and restore they should all be in place.

Good Luck

Dan

I had Oracle and SQL Server 7.0 running on the same machine before and I did not encounter any problems, it was coupl eof years ago and I don't...

Can you ellaborate on your problem.

Thanx Dan

quote:

---

I have a select statement that has many 'ands' where one side uses the same thing...

Oh yeah I forgot to mention if you have not assigned default value to a variable, and it contains a null value the datalength will be zero.

Duplicate post see http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=4303&FORUM_ID=8&CAT_ID=1&Topic_Title=Allocation+memory+for+a+variable%2E%2E%2E&Forum_Title=T%2DSQL

quote:

---

When is allocate memory for a variable in a Script T-SQL?

In the DECLARE instruction?

Or in...

Char is spacepadded, varchar is variable length.

IF you use datalength function of @CharType char(10) it will always return 10, if you use same variable declared as varchar(10) and the value...

Use bulk copy to move the file into a temp table.

Select xml from the table into a variable then use sp_xml_preparedcoument to get the handle.