You have missed...

The discussion I want is about having a column where you have a statement, or an UDF, in a form of a VARCHAR, and with an SProc have that...

Compare it with a single function reading the data from a single Calendar table having holiday records specific for different locations, and simple user interface which allows users update...

Back in the 1980'2, when I was on ANSI X3H2, the question of whether or not to require a primary key in the table came up in the committee. Back...

BY DEFINITION, a table has to have at least one key. Your narrative is for a deck of punch cards written in SQL. Exactly what is this data?

>> I have one table called A. A has dependencies on B. B has dependencies on c. C has dependencies on D. A has dependencies on B,C,D. <<

Please read...

https://books.google.com/books?id=i-19BAAAQBAJ&pg=PA326&lpg=PA326&dq=celko+update+steps+sequence&source=bl&ots=cQLK5RSXru&sig=ZxDMK3uizuhrEOgrh6guQYJVF6A&hl=en&sa=X&ved=0ahUKEwjqjOi5uMnOAhVP-GMKHTbHAsIQ6AEIJDAB#v=onepage&q=celko%20update%20steps%20sequence&f=false

And I got the back seat cover washed and returned without killing Ms Mya, the quietest, gentlest dog we have ever owned. 🙂 I just got through...

I apologize for this half answer, but in some of my books I have an update statement that uses a case expression (not a case statement, please?) To move things...

skeleton567 (8/16/2016)

---

When I started writing code as far back as 1969, the accepted method was to add 5 to one place to the right of the desired result length and...

I used to be a statistician in a former life, but I do not remember ever seeing a really good book/paper/magazine article on all the problems of rounding! Usually all...

Me! Me! 😛 But which one? There have been:

1) go up or down from "x5" alternating.

2) go up or down from "x5" in a uniform random distribution.

3) go up...

The ANSI/ISO standards define rounding as "implementation defined", so you have to be careful. Google scientific versus commercial rounding (I prefer this because it is more "set oriented" than "single...

Nusc (7/31/2016)

---

IF you don't mind saving that xlsx as a csv file and importing as a flat file source so there are no differences would be great.

Year , name, latitude,...

Adam Mechanic had an improved technique. The only downside was that if the adjacency list had a cycle, it was bitch to find. The old stack algorithms could be written...

What you are doing is modeling a hierarchy with an adjacency list model (basically fake pointer chains). Google around for "nested sets model" and use it instead. After all, SQL...