twin.devil (12/3/2014)

---

Koen Verbeeck (12/2/2014)

---

Eirikur Eiriksson (12/2/2014)

---

Just and only for fun, here is a slightly twisted solution, recommend following Koen's suggestion

😎

DECLARE @STR VARCHAR(100)='My name is Shiva';

DECLARE @XSTR VARCHAR(MAX) = 'SELECT(SELECT CHAR(32)+Y.XN...

Quick thought, use a calculated column for an "active" flag, here is an example, not a full solution but should be enough to get you passed this hurdle

😎

USE tempdb;

GO

SET NOCOUNT...

Quick sample code, not a complete solution but should be enough to get you passed this hurdle

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID('dbo.TBL_DETECT_DUPES') IS NOT NULL DROP TABLE dbo.TBL_DETECT_DUPES;

IF OBJECT_ID('dbo.SVFN_COUNT_DETECT_DUPES_CODE') IS NOT...

swoozie (12/2/2014)

---

I tried to do the following:

1) remove the references to the extra table from the XSD = didnt work

2) Change the name of the column in the XSD still...

Ed Wagner (12/2/2014)

---

Eirikur Eiriksson (12/2/2014)

---

Luis Cazares (12/2/2014)

---

Sean Lange (12/2/2014)

---

David Burrows (12/2/2014)

---

Luis Cazares (12/2/2014)

---

...it can be easier to start from scratch if we can understand the problem, than fix a complete...

Luis Cazares (12/2/2014)

---

Sean Lange (12/2/2014)

---

David Burrows (12/2/2014)

---

Luis Cazares (12/2/2014)

---

I have...

+1

This is very annoying to say the least, hope it gets corrected!

😎

Koen Verbeeck (12/2/2014)

---

Eirikur Eiriksson (12/2/2014)

---

Just and only for fun, here is a slightly twisted solution, recommend following Koen's suggestion

😎

DECLARE @STR VARCHAR(100)='My name is Shiva';

DECLARE @XSTR VARCHAR(MAX) = 'SELECT(SELECT CHAR(32)+Y.XN FROM(SELECT...

Just and only for fun, here is a slightly twisted solution, recommend following Koen's suggestion

😎

DECLARE @STR VARCHAR(100)='My name is Shiva';

DECLARE @XSTR VARCHAR(MAX) = 'SELECT(SELECT CHAR(32)+Y.XN FROM(SELECT ROW_NUMBER() OVER (ORDER BY...

Sean Lange (12/1/2014)

---

Is it just me or is LinkedIn quickly becoming the most useless website in existence? It seems that all that is there is recruiters always trying to get...

Sean Lange (12/1/2014)

---

Matt Miller (#4) (12/1/2014)

---

Ed Wagner (11/25/2014)

---

Eirikur Eiriksson (11/25/2014)

---

Ed Wagner (11/25/2014)

---

Eirikur Eiriksson (11/24/2014)

---

Jeff Moden (11/24/2014)

---

Evil Kraig F (11/24/2014)

---

Jeff Moden (11/24/2014)

---

Eirikur Eiriksson (11/24/2014)

---

Just a quick question to "the thread", am...

Fixed the link, sorry about that;-)

😎

Quick thought, you might want to look at sparse columns as the fourth alternative in addition to the options

aaron.reese mentioned, recent discussion on the subject on this thread

😎

Edit: fixed...

Further on Jeff's reply, here is a sketch / pseudo code showing how a cursor-less equivalent could look like. Note: this may NOT work as it is, some tweaking with...

Jampandu (11/29/2014)

---

Luis/Erickur,

Instead of computing every time, I am planing to insert all the unique sequences into one look up table.

CREATE TABLE Lkup_UniqueSequenceValues

(

Id bigint identity(1,1)...