Quick suggestion, use the .nodes function

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @TXML XML = '<xml-response>

<clear-fraud>

<clear-fraud-stabilities>

<clear-fraud-stability>

...

mrjae (3/6/2016)

---

Hi there,

I am new to sql server and i am practicing on SQL Express. I have created a table and in error I have duplicated rows. My first...

Quick suggestion, get Grant's book on execution plans[/url]

😎

Quick and simple solution with LEAD()

😎

USE tempdb;

GO

SET NOCOUNT ON;

declare @overlap table

(

ID int identity,

infoname char(10),

code char(10),

mods char(30),

type varchar(30),

effective date ,

termination date

)

insert into @overlap

select 'DUMMY','99205','C','*','01/01/2008','12/31/2100'

insert into @overlap

select 'DUMMY','99205','C','*','01/01/2009','12/31/2100'

insert into @overlap

select...

Quick suggestion, similar to Luis's

😎

DECLARE @LOG_STRING VARCHAR(200) = 'Login failed for user ''User1''. Reason: Failed to open the explicitly specified database. [CLIENT: 11.11.11.11]';

SELECT

SUBSTRING

...

MotivateMan1394 (2/28/2016)

---

Hi

Ask help from old-hands

We have a server : win 2008 R2 enterprise (virtual machine) - Sql server 2014 - sp1

we had 22 cpu core which...

farax_x (2/19/2016)

---

Why Try Catch doesnt catch collation exceptions? How can I handle it?

BEGIN TRY

IF '1' COLLATE Arabic_CI_AI = '1' COLLATE Arabic_100_CI_AI

...

Sean Lange (2/15/2016)

---

Grant Fritchey (2/15/2016)

---

Hugo Kornelis (2/15/2016)

---

jasona.work (2/15/2016)

---

So, a question for everyone:

How do you feel if someone comes back and tells you that they tested a solution you provided before...

Lynn Pettis (2/15/2016)

---

We got you...

yup, the difference between \ and / :pinch:

😎

Old oracle habit

😎

koti.raavi (2/15/2016)

---

Hi to all,

I have got a one column in table containing different Client ID's. There are 3000 rows in a table ...I need a data with comma separated(each row...

Phil Parkin (2/12/2016)

---

Grumpy DBA (2/12/2016)

---

"Give a man a fish and he eats for a day. Teach a man how to fish and he eats for a lifetime."

I believe Brandie...

Quick and simple suggestion, encapsulate the SMO in a CLR.

😎

Slightly longer suggestion here

😎