Lynn Pettis (2/7/2012)

---

Now that it is officially posted on facebook, I can start telling everyone.

Kassondra gave birth to a healthy baby boy yesterday in Germany. Grayson Matthew was born at...

Are you trying to throw this into a loop?

Nope. I have used different ports.

This should help you start figuring it out.

SELECT a.Personname AS Buyer, b.PersonName AS Seller,a.transactionnum

FROM sometable a

INNER JOIN sometable b

ON a.transactionnum = b.transactionnum

WHERE a.personnametype = 'buyer'

AND b.personnametype = 'seller'

I think you will be better using a static port. I have seen it work better with JDBC to use a static port when dealing with named instances.

I think it is more related to the Central management server and it being RTM. Let us know how the patching goes.

Are you referring to a sql agent job step?

Without building some sort of support system (tables etc) to record parameter values at the end of each step, the agent does...

If the users cannot be interrupted by the log restores, then use transactional replication.

Does the application require that it be xml in order to use that info? It seems like a backwards way of doing this to me. You receive the...

words with friends

Agreed - no...

Adi Cohn-120898 (2/7/2012)

---

Hope that I undestood what you need:

DECLARE @data table (n INT)

INSERT @data

SELECT 1 UNION ALL

SELECT 10 UNION ALL

SELECT 11 UNION ALL

SELECT 12 UNION ALL

SELECT 13 UNION ALL

SELECT...

Do you have any control on the xml that is coming to you?

We had a case where the app was creating the xml for us to consume in the database...

Try this

DECLARE @data table (n varchar(2))

INSERT @data

SELECT 1 UNION ALL

SELECT 10 UNION ALL

SELECT 11 UNION ALL

SELECT 12 UNION ALL

SELECT 13 UNION ALL

SELECT 14 UNION ALL

SELECT 15 UNION ALL

SELECT 16...

are there other servers being managed by this central server that are > SQL Server 2008 RTM? My first recommendation would be to get that server patched.