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

Have you simply tried clearing proc cache for the database that has the code that's causing you fits, which would cause a recompile of your all the code for that...

What is the code to sum this row of data (trip duration in hours and minutes, and about 800,000 rows). Characters are varchar, and I have tried casting based...

Since half of your replies have been flagged as SPAM and they all seem to be in the same vein of acknowledgement...

Can any enlightened cloud industry folk let me know why enterprise tech companies - particularly those cloudy ones - LOVE having a big, massive, expensive Sales Kick Off event...

Heh... ah... but we ARE judging. 😀 The third party code and database design sucks. 😀 😀 😀