Heh... Had to laugh...I was just thinking that "Revo-Scalepy" (revo-sca-lepy) might make a great name for a line of blenders and food processors. 😀 😀 😀

Hi Steve, thanks but what you are providing here is calculating percentage. My ask is to get an average of 4 month percentage (or 5 or 6...

Looks like Frederico was ultimately correct.

Agreed but I've also found that it makes people complacent about...

Yep... I totally get that but this is one of those places where...

To Frederico's point, it may be that...

As I myself are not sure if I still want to continue to be a DBA or move on to another field of work or even moving up to...

I guess my question would be.... Why not just try it and see?  Then post the answer here and Google will have a place to land the next time someone...

Yes.  The following will do the trick for LfCr, CrLf, Cr, and Lf... Just replace the table name and the column name with your actual table and column names.

            
January 9, 2023 at 8:07 am
            
#4135331

            
            
                                                
        

Just for convenience, here's the formula.  Replace the "t.N" with the name of your IDENTITY column that starts at zero.

CONCAT('10.',CHAR(66+t.N/1000),RIGHT(CONCAT('00',t.N%1000),3))

EDIT:  Forgot to add that it would be...

• This reply was modified 3 years, 2 months ago by Jeff Moden.

Yes.  And, it's easy.  Start an IDENTITY column at "0".  Add a computed column with the formula from my previous query but replace the "t.N" in both places with the...

Too funny.  I wish it returned an error instead.  One that says, "Dude!  Just because this is 2022, you shouldn't expect anything different here!" 😀

I guess I don't understand why you think that you need to list every column.  If you're trying to export the whole table, then export the whole table.

Heh... there's definitely a need for the art.  Here are some folks that prove that...

https://samcurry.net/web-hackers-vs-the-auto-industry/

Spooky stuff.

And then, there are things like this...

https://www.itprotoday.com/career-development/amazon-slash-more-18000-jobs-escalation-cuts

I know stuff like this happens but this smacks of poor management and "over-hiring" practices.