DECLARE @DocHandle int

DECLARE @xmlString XML = N'<TAG1><A>1</A><A>2</A><A>3</A><A>4</A><A>5</A><A>6</A></TAG1>'

EXEC sp_xml_preparedocument @DocHandle OUTPUT, @xmlString

SELECT *

FROM

OPENXML

(@DocHandle, '//TAG1/A',1)

WITH (A VARCHAR(5) '.')

EXEC sp_xml_removedocument @DocHandle

WE sell software using SQL Server. Another department had lots of customer pc's that did not install the express edition correctly.

I also had problems pre SP1 installing SQL server,...

With a trigger you would not be able to have a transaction when inserting into the final table, as it will effectively insert it one row at a time as...

What about a flag on the 1st proc to indicate if you are finished?

What about calling the 2nd proc from the client?

Are you also making sure that the temp table...

Yes, adventureworks will be helpful.

The code you posted creates a cursor that iterates through a normal select statement - then you execute a select statement with a where clause that is just one of...

I prefer to have clustered indexes on all my tables. I am not saying you should never have a clustered index.

Look at this post for more info.

http://www.sqlskills.com/BLOGS/KIMBERLY/post/The-Clustered-Index-Debate-Continues.aspx

I am not as dogmatic on the no cursor thing... sometimes you need it. This does not seem to be one of those times!

This is quick and dirty, without data...

I'm with Jeff. The update gives me exactly what I would expect.

One problem is security. Your user will need permission on both databases to use theUDF's.

Another is portability - you will need both databases to operate, not just one. That...

SELECT

CASE DATEPART(MINUTE , [Date and Time])

WHEN 30 THEN DATEADD(MI,-30 , [Date and Time])

ELSE [Date and Time]

END

,SUM(Value)

FROM @test-2

GROUP BY

CASE DATEPART(MINUTE , [Date and Time])

WHEN 30 THEN...

Please add the ddl and row insert statements next time.

This is just a quick and dirty to do the numbering...

declare @test-2 table (code int , item_code nvarchar(10) )

INSERT...

When you have loaded the dll into the database, the dll can effectively be removed from the directory. SO to be clear, the only time the dll needs to be...

What I am missing is that the error is:

Msg 5133, Level 16, State 1, Line 1

Directory lookup for the file "W:\myDB.mdf" failed with the operating system error 3(The system cannot...

I read the link and I do not get how it helps. Can you explain?

Try..Catch is fine, but the problem in this case is that the catch block is...