Hi Jeff,

in this case you will have to use CDATA (Character Data) elements in the construction of the XML.

😎

Here is the function with the necessary modification to handle any type...

ma701ss (12/17/2016)

---

Hi Wryan, no I've not tested before but just ran it in SSMS and got the following:

Msg 245, Level 16, State 1, Procedure Validate_User, Line 18

Conversion failed when converting...

Phil Parkin (12/16/2016)

---

Grumpy DBA (12/16/2016)

---

Wow, today's spam includes a warning about BOOTY POP... dang, just as I was about to order cases of BOOTY POP for my family and friends...

ThomasRushton (12/16/2016)

---

Grant Fritchey (12/16/2016)

---

Oh no.

Don't let anyone do that. It's horrible. Quick, go and change...

Edvard Korsbæk (12/15/2016)

---

Hi all!

I have a database where app. 10.000 records are deleted/updated/inserted pr. day.

I have understood from other sources, that i should reindex the db on a regular basis.

Locally,...

keithy_sunny (12/15/2016)

---

I am checking system base table at https://msdn.microsoft.com/en-us/library/ms179503.aspx and system internal views at https://technet.microsoft.com/en-us/library/ms189600(v=sql.105).aspx

For base table sys.syscolpars, is there a corresponding system view for it so that I can...

Quick questions:

Any multiple currency subjects?

Currency exchange rates?

Exchange rate history?

Aggregation across currencies?

😎

Igor Micev (12/13/2016)

---

If you install SQL Server 2016 then you'd be much better. The Standard is very close to Enterprise. Find them here https://msdn.microsoft.com/en-us/library/cc645993.aspx

For SQL Server 2014 find this reference...

zouzou (12/13/2016)

---

Hello all,

The same query with a group by clause I try to run on SQL Server 2005 and on SQl Server 2014 but it seems that every time i...

prafullaahirrao (12/12/2016)

---

Hi All,

I have one table Employee which has 2 columns EmpId and EmpName with thousand's of rows in it.

Table does not have any key as of now.

If I execute...

pankaj 43245 (12/12/2016)

---

Hi Folks,

I am new to SQL and i have table which has column FULLNAME (Last name, firstname) & USER EMAIL (firstname.lastname@corp.com) and i m looking to replace the...

KGJ-Dev (12/12/2016)

---

Hi,

Below the sample query to play with

Declare @UserGroup nvarchar(MAX);

SET @UserGroup = 'UserGroup1|User1|User2|User3&UserGroup2|user4|user5|user6&Usergroup3|user7|user8|user9';

selecT uc.UserGroup, us.Item

FROM dbo.DelimitedSplit8K(@UserGroup,'&') gs

CROSS APPLY (SELECT LEFT( gs.Item, CHARINDEX( '|', gs.Item + '|') - 1) AS...

The behaviour and handling of characters is exactly the same on both 2005 and 2014, in fact it hasn't really changes any since SQL Server 6.5, upgrade is not going...

Beatrix Kiddo (12/12/2016)

---

Do you have Vick's First Defence (First Defense ;-)) nasal spray over there? I find it quite good- not sure how scientific it is, but my theory is...

rodjkidd (12/12/2016)

---

Eirikur Eiriksson (12/9/2016)

---

ChrisM@Work (12/9/2016)

---

Eirikur Eiriksson (12/9/2016)

---

ChrisM@Work (12/9/2016)

---

Brandie Tarvin (12/9/2016)

---

rodjkidd (12/9/2016)

---

ChrisM@Work (12/8/2016)

---

rodjkidd (12/7/2016)

---

Eirikur,

I'm about a 20 minute walk to the High Holborn Caffe 1882. Let me know if you still...