Hello,

I wonder if there was any change since 2009 when this subject was raised and the solution - provided.

I have a process, building xml of invoices (hence I cannot use...

Thank you for the article - will read it now.

yes - for a quick mock-up to present the requirement and my solution.

Thank you Wayne.

I will try to apply your suggestion to my current logic and see what comes out.

With regards to posting examples, I didn't write one, as didn't expect a...

Thank you Craig,

Sadly this blog deals with WHERE part, where my issue is with the columns I select to present.

Thank you for pointing to the article!

Thank you all for the suggestions and especially for the script!

Much appreciated!

Steve Jones - SSC Editor (8/12/2015)

---

First, understand the SQL Management Studio is a client application. It doesn't do anything on a server, even if it's running on the host that...

While good, both solutions need SQL DB Engine & Agent installed on server C, but it's not clear from the description if it is or not. 2 will also need...

Thank you, Jason

Sadly I come from an Oracle background. Can you point me to some documentation I can read how to implement your suggestions, please?

Many thanks

I see this article has been re-posted just now, after 3 years of dramatic technological progress.

I wounder if still has a value? Also it would be great if one could...

Thank you Celco,

Meanwhile I have sorted it out already, but still would like understand benefits of your solution, so here are some answers to your questions / statements

which will help...

Jason A. Long (5/12/2015)

---

SQL doesn't really have a concept of copy/paste vs cut/paste, so that doesn't really add a lot of clarity.

Are trying to move 4451 under 2, all alone...

Is this what you're up to?

DECLARE @isExists INT

EXEC master.dbo.xp_fileexist 'E:\ZipBatches\ReactorBatch.zip', @isExists OUTPUT

IF @isExists = 1

BEGIN

USE msdb

EXEC sp_send_dbmail

@profile_name='CFServerMail',

@recipients='georgeg@communityfuels.com',

@subject='Test Attachment',

@body='An attachement has been included in this email.',

@file_attachments='E:\ZipBatches\ReactorBatches.zip'

END

ELSE

BEGIN

SELECT 'What do...

Jason A. Long (5/12/2015)

---

Either it's not clear what you're trying to do or you're over think it... You're working with a simple adjacency list, which means that you can easily...