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

Fundamental error here, ELSE is the last / unmatched clause, not a part of the higher case flow hierarchy, suggest you remove all but the last else statements within each...

Gazareth (11/25/2014)

---

SQLRNNR (11/24/2014)

---

Eirikur Eiriksson (11/24/2014)

---

SQLRNNR (11/24/2014)

---

Jeff Moden (11/24/2014)

---

Eirikur Eiriksson (11/24/2014)

---

Just a quick question to "the thread", am I missing something or is XML getting more popular? Just noticed that this...

swoozie (11/25/2014)

---

I do not have an example of the xml to post, not allowed. The file is not large.

It organizes perfectly except on the 5th table that I Need to...

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 I missing something or is XML getting more popular?...

+1 (vote)

😎

No, the column has a unique constraint

4. Will query 2 really gains...

SQLRNNR (11/24/2014)

---

Jeff Moden (11/24/2014)

---

Eirikur Eiriksson (11/24/2014)

---

Just a quick question to "the thread", am I missing something or is XML getting more popular? Just noticed that this topic on the XML...

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 I missing something or is XML getting more popular? Just noticed that this...