If the hierarchies are DAGs (Directed Acyclic Graphs) with no loop backs, no "crossed legs", and are true "Adjacency List" (parent/child only) hierarchies, then I recommend that you study the...

I just wanna know what he actually wants. 😀

#1) In terms of I/O and time, which is faster? running Index Rebuilds or Running Updatestats or is it depens on case to case?

#2) I have a database called...

It shouldn't be too...

Agreed. That would also decide if the last 5 minute period appeared to be in the next hour or not if hourly calculations from the original average calculations needed to...

p.s.  This is really going to be fun when they need another 10 million unique random values to fold into the first 10 million. 😀

I read it as "the number should be between 10 and 15 digits in length and the first two digits must be 11".

Some clarification from the OP would be...

Yep... and he never got an answer to his question on any of those.  On one of the earlier ones, he did a work around by using VBA , but...

Your timestamp column is a UNIX timestamp based on Seconds.  Just use integer division to divide that number by 300 and you'll get the GROUP BY value for...

reduce the length to

The numbers should begin with 11. The minimum length of the number should be 10 The maximum length of the number should be 15...

Your timestamp column is a UNIX timestamp based on Seconds.  Just use integer division to divide that number by 300 and you'll get the GROUP BY value for your Average.

Edit: ...

reduce the length to

The numbers should begin with 11. The minimum length of the number should be 10 The maximum length of the number should be 15 Need to...

Is it possible to have a function that is stored somewhere other than in Programmability-> Functions ->  Scalar-valued Functions of each database like in the master database and...

Hi All,

I need to generate random unique numbers for 10 million records.

Here is my requirement

1. The numbers should begin with 11.
2. The minimum length of the number should be...

I called him out on the fact that he had 4 threads asking exactly the same thing - he didn't like it

https://www.sqlservercentral.com/forums/topic/ssrs-rendering-format-excel-change -- I made the comment on this...