Here's the solution - add a COMMIT in the OPENROWSET:

SELECT * FROM OPENROWSET('SQLNCLI', 'Server=(local);UID=<uid>;PWD=<pwd>', 'SET NOCOUNT ON;EXEC robot5.tmp.test_insert ''22'';COMMIT;')

But why?

OK, this is the solution...

SELECT1 AS Tag,

NULL AS Parent,

xmlData AS [campaign!1],

NULL AS [contacts!3],

NULL AS [contact!2]

FROM#campaigns AS oc

WHEREID = 1

UNION ALL

SELECT3 AS Tag,

1 AS Parent,

NULL,

NULL,

NULL

UNION ALL

SELECT2 AS Tag,

3 AS Parent,

NULL,

NULL,

con.xmlData

FROM#Contacts...

oh my god. sure you all are right. I think it it was too easy to solve it by myself.

there are some bugs in my head...

Sorry about my bad explanation. I try to specify it.

I have a table which contains the first digits of telephone numbers (column Number)

IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.SCHEMATA...

no, this counts the rows...

I need the information about the biggest hit rate.

When I search for 99911 both rows matches, 999 and 99911. But the hit rate of 99911 is...