Bruce W Cassidy (3/22/2009)

---

[font="Verdana"]Heh. Not when you have an enterprise architect who insists that the appropriate...

Bruce W Cassidy (3/22/2009)

---

[font="Verdana"]For a real world scenario, can I suggest you consider world-wide logistics? Say you have sites around the world generating shipping bills (bills of lading?), but...

John, it's all so cool, but nothing's gonna work in SQL2000.

Sorry.

Jeff Moden (3/20/2009)

---

Heh... nope... I don't believe I ever wrote that... If it were for a sequence table, I'd have written something like the following (partial code)....

UPDATE NextID

...

Michael Valentine Jones (3/19/2009)

---

You will have to decide what to do in cases where the elapsed time is more than 99 hours. This code will truncate the hours at...

Bruce W Cassidy (3/19/2009)

---

[font="Verdana"]Why did I recommend GUIDs?

A few years back I was involved in a project that had to synchronise data from multiple sources into one source. The...

J (3/19/2009)

---

Also, you should use the GUID as a last resort. I saw something about that being more prone to index fragmentation requiring the comparison of 38 characters instead of...

foxjazz (3/19/2009)

---

Sergiy, as far as the bands. How could I use identity and keep with the rule of source bands.

Where source 1 data must have pk numbers between 1...

Bruce W Cassidy (3/19/2009)

---

[font="Verdana"]One common business case for generating sequences is for invoice numbers. For some reason, customers like to see their invoice numbers being counted just for them....

Greg Snidow (3/19/2009)

---

Sergiy, the quote button is taking me to the wrong post, but you said

in your last post. Do...

Why?

I believe

pipe1 1

pipe1 2

pipe1 3

will be...

foxjazz (3/19/2009)

---

Business case for identity insert not being in a couple of my important tables. The reason is that I have used bands of identities, and certain types of data...

And talking about syntax inprovements in SQL 2k5 and 2k8 I'd say it's not good at all.

By introducing comfort of procedural programming in stored procedures MS invites developers to move...

How about this:

[dbo].[USPDeleteAnswers] 'xxx','1,3,5) or 1=1--'

Guys, I'm...