Welcome to the SQLServerCentral forums.

This should be easy to sort out but it would help if you could provide some DDL, a few rows of sample data and an...

I think there is. I generally avoid scalar user defined functions like the plague but check this...

Matt Miller (#4) (8/24/2016)

---

mister.magoo (8/24/2016)

---

Sergiy (8/24/2016)

---

mister.magoo (8/23/2016)

---

To answer your question about how (not getting involved in why)

declare @x xml;

select @x=(

select ''+b

from

(

select 'hello;friend'+CHAR(13)+CHAR(10)

union all

select 'my;world'+CHAR(13)+CHAR(10)

)a(b)

for xml path(''),type);

select @x.value('(./text())[1]','nvarchar(max)')

the important things...

ben.brugman (8/23/2016)

---

XML

is not the purpose and not a target it is only the means to get to something.

So why FOR XML? The reason for this is that FOR XML concatenates...

Have a look at Data Driven Subscriptions.

It looks like you can re-write your code to eliminate the cursor - that cursor is going to slow you down. I would also run this stored procedure using WITH...

What is the purpose of this?

If the primary purpose is...

As Phil eluded to, this is best handled via source control. Another way to get collect definitions is to use dbo.sp_GetDDL[/url]

This is a script I use to pull all your...

:hehe::hehe::hehe: +1

I never heard the word growlingly before so I looked up the Webster definition.

The only way to know what's happening now and how adding an index will change things is to look at the execution plan before and after and test it.

Based on...

Great article. Well done. Scary.

Francis Twomey (8/22/2016)

---

Thanks for the responses. Here is my code currently:

INSERT INTO item_relation_table

(parent__id,

child__id,

relation)

SELECT xm.1_id, xm.2_ID,

'A',

from tablexm xm

where xm.1_id != xm.2_ID and

exists(select 1 from item ip WHERE ip.mfg =...

This should be fine with SQL Server 2005+

-- sample data

CREATE TABLE #calendarTable (calDate datetime NOT NULL, workingDay char(1) NOT NULL);

WITH base AS

(

SELECT TOP (366)

...

I have a couple ideas I'll play around with when I'm at a PC shortly.

tinyint can't be negative 😉

I have...