Shadab Shah (11/11/2013)

---

Hi Floks,

I am trying to get my hands dirty with XML in SQL Server. I have tried MSDN and some other links which google suggested but i think...

Using DelimitedSplit8k (link in my signature), you could accept a delimited list like so:

use tempdb;

-- create tablea for demo

IF OBJECT_ID('tempdb..tablea') IS NOT NULL drop table tablea;

CREATE TABLE tablea(id int identity...

timvil (11/11/2013)

---

Thanks MM for your fast reply!

However I didn’t get it to work. Maybe problem is in Column1 data type, it is ntext. I read somewhere that it couldn’t be...

First, in the future try including your sample data like this:

DECLARE @Store TABLE (s_yr int, s_mo tinyint, storeName varchar(10))

DECLARE @Store_Sales TABLE (s_yr int, s_mo tinyint, storeName varchar(10), NumberOfSales int)

INSERT...

You can do this using a recursive CTE like so:

WITH...

I would also recommend: http://en.wikipedia.org/wiki/ACID.

I think this will get you what you need:

DECLARE @Result varchar(1000);

WITH x(xx) AS (select * from Xml_Export listing for xml auto ,elements ,ROOT('Listings'))

SELECT @Result='<?xml version="1.0" encoding="UTF-8" ?>'+xx

FROM x

--this will...

dwain.c (11/6/2013)

---

Alan.B (11/6/2013)

---

You could do something like this (I changed @name to @names):

DECLARE @names varchar(max);

WITH names(n) AS

(

SELECT Name

FROM dbo.iNamesExcel$

FOR XML PATH('')

)

SELECT @names=CHAR(39)+LEFT(n,LEN(n)-1)+CHAR(39)

FROM names

Then, in your DSQL change your...

Almost there... This was the first draft and, though it is processing all your variables, I made a mistake(s) somewhere in my formulas; I had very limited time. The reason...

Eric Mamet (11/7/2013)

---

Hi everyone, sorry for being so slow but I just did not have time to go through the article before...

Yes, it is very interesting and intriguing but...

I am pretty sure that you can turn that into an inline table valued function. It isn't something I can do quickly but I will take a shot at this...

You could do something like this (I changed @name to @names):

DECLARE @names varchar(max);

WITH names(n) AS

(

SELECT Name

FROM dbo.iNamesExcel$

FOR XML PATH('')

)

SELECT @names=CHAR(39)+LEFT(n,LEN(n)-1)+CHAR(39)

FROM names

Then, in your DSQL change your and displayName...

I would add that you can also do it like this:

--sample data

SELECT * INTO #test

FROM (VALUES (1,'blah AAA'),(2,'bbb bbb bbb'),(3,'AAA ccc')) t(id,val);

SELECT * FROM #test;

WITH your_table AS

(

SELECT * FROM...

I'm short on time here but will help get you started. Nothing you are doing sounds too difficult using...

matt6749 (9/23/2013)

---

Hello,

I have a website/database app with a text column that stores a user's bio where users are not allowed to embed their phone number (e.g. similar to a dating...