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

Quick suggestion while we are at it, let's keep it as simple as possible:

😎

Function GenerateUserPreferedNumberSequence(

{Optional StartValue] Default 1.000000 Real number

[Optional EndValue] Default MAX_INT ...

Jampandu (11/26/2014)

---

Hi Experts,

I need a way to generate some random unique sequences for one of the column (+5 increment for each row)

sequences as below..

A00-A05

A00-A10

A00-A15

…………..

…………..

…………..

A00-A95

A00-B00

A00-B05

…………..

…………..

…………..

A00-Z95

A01-A00

A01-A05

…………..

…………..

…………..

…………..

Z99-Z95

NOTE : Need to...

Quick suggestion, combine the conditionals, consider this example which does the same as your code

😎

SELECT

CASE

WHEN Division...

If I remember correctly it was 135 after my vote

😎

There are few options, use XSLT to transform the structure, change the XSD using something like xsd:all and the Type/Name attributes or simply parse the XML with XQuery in SQL...

Quick suggestion, have a look at this post which tackles similar problem

😎

Jeff Moden (11/25/2014)

---

Shifting gears real hard, could you good folks take a look at the following post? I think it's a really important subject even if I wasn't the...