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)...

SQLRNNR (11/29/2014)

---

Luis Cazares (11/28/2014)

---

SQLRNNR (11/28/2014)

---

Koen Verbeeck (11/28/2014)

---

Luis Cazares (11/27/2014)

---

Koen Verbeeck (11/27/2014)

---

kaspencer (11/27/2014)

---

When you have an Americo-centric question like this, you should provide an alternative, such as one based on St....

Quick thought, since the alpha and the numerics have fixed places in the sequence construct/pattern, why not include all 26 alphas instead of degrading the capacity of the sequence to...

Quick suggestion, place the concatenation inside the convert function. You can use the "describe first result set" procedure to examine the difference.

😎

Jampandu (11/29/2014)

---

Thanks Eiriksson .. I need to add this logic in computed column along with bigint identity(5,5). will try to exclude alphabet letters like I and O while computing...

gouri92 (11/29/2014)

---

Hi,

There is email address in my datablse table column as username

I have to select it from database in such a way so that first two letter and last

two letters...

Jampandu (11/29/2014)

---

Thanks you very much Eiriksson..Excellent solution with good matrix explanation..

But Need to exclude alphabet letters like I and O those easy to confuse letters with numbers from the...

The sequence asked for is a combination sequence of alpha (bijective) hexavigesimal(base 26) and numerical decimal (base 10). The pattern proposed has eight significant digits with the maximum value of...

Quick questions, what is the tempdb configuration and can you post the code for the dbo.Split function?

😎

BTW: Consider posting the full execution plan in XML format, the information you posted...