Introduction

Question

Post reply

Introduction

Alxender

Valued Member

Points: 64
More actions
November 16, 2022 at 11:18 am

#4113662

Hi, I'm new here. My name is Alxender.

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Eirikur Eiriksson SSC Guru Points: 182948 More actions · Answer 1

Eirikur Eiriksson

SSC Guru

Points: 182948

November 16, 2022 at 12:47 pm

#4113709

Hi Alexander,

and welcome to the forum.

😎

Jeff Moden SSC Guru Points: 1004641 More actions · Answer 2

Greetings and welcome aboard.

Just to "grease you up" for asking questions, I recommend you read and understand the article at the first link in my signature line below. If you end up having code performance issues rather than code functionality or "how to" issues. the article at the second link in my signature line below can help you help those eager to help you.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Alxender Valued Member Points: 64 More actions · Answer 3

Thanks to all to welocome me. I hope , i'll gain more and more knowledge here.

Jeff Moden SSC Guru Points: 1004641 More actions · Answer 4

In tha

Alxender wrote:

Thanks to all to welocome me. I hope , i'll gain more and more knowledge here.

In that case... Do you know what a "Tally" or "Numbers" table or function is and how it can frequently be used to replace a WHILE loop or an incremental rCTE (Reccursive CTE that produces a numeric series), the latter of which is actually worse than a WHILE loop? If not, see the articles at the last two links in my signature line below in reverse order (the "intro" first).

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Alxender Valued Member Points: 64 More actions · Answer 5

Your articles are informative . Thanks for the info.

Jeff Moden SSC Guru Points: 1004641 More actions · Answer 6

Thanks for the feedback.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)