Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,341 through 17,355 (of 59,067 total)

RE: Concatenate strings

ScottPletcher (6/30/2016)
Jeff Moden (6/24/2016)
Shifting gears a bit and depending on how that's used, it could become a performance problem due to the implicit conversions of the string literals. Since...
--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)

June 30, 2016 at 8:46 pm

#1887988
RE: What's a Code Smell?

robert.sterbal 56890 (6/30/2016)
I reproduced the list here:
https://sqlserver.miraheze.org/wiki/Code_Smells
I hope to set up the individual pages, and put them in appropriate categories, it there is interest.
Anyone can add to or edit the...
--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)

June 30, 2016 at 3:45 pm

#1887978
RE: Concatenate strings

ammit.it2006 (6/29/2016)
I hope this is you are expecting........
DECLARE @DBs TABLE ( DBname NVARCHAR(100) )
DECLARE @database varchar(100)
DECLARE @database1 varchar(100)=''
INSERT INTO @DBs
VALUES ( 'A' ),
...
--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)

June 30, 2016 at 3:42 pm

#1887977
RE: Return string between 2 characters from the end of the string

ammit.it2006 (6/29/2016)
It should work I think. Please let me know if need some more changes..
DECLARE @a varchar(20) = 'INV CRT IS15000467 1'
DECLARE @b-2 varchar(20) = 'INV CSH IS15000442 10'
select...
--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)

June 29, 2016 at 11:35 am

#1887691
RE: SQL Server 2016 is Out and It's Fabulous!

GilaMonster (6/29/2016)
Jeff Moden (6/28/2016)
Steve Jones - SSC Editor (6/28/2016)
Jeff Moden (6/25/2016)
From the Article:
“This doesn’t work like it used to.”
While I agree that it probably has fewer bugs that previous...
--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)

June 29, 2016 at 11:31 am

#1887690
RE: Email or Username

pabechevb (6/29/2016)
Iwas Bornready (6/29/2016)
Jeff Moden (6/28/2016)
Meh... just have them use their SSN. :-):-D:-P;-):hehe::sick:
I'm assuming you're joking. Though they are supposed to be unique, working in the health industry we...
--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)

June 29, 2016 at 11:26 am

#1887689
RE: Email or Username

Iwas Bornready (6/29/2016)
Jeff Moden (6/28/2016)
Meh... just have them use their SSN. :-):-D:-P;-):hehe::sick:
I'm assuming you're joking.
Heh... what gave it away? The 5 different smiley faces or the barf-face? 😛
--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)

June 29, 2016 at 11:23 am

#1887688
RE: Email or Username

Meh... just have them use their SSN. :-):-D:-P;-):hehe::sick:
--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)

June 28, 2016 at 11:21 pm

#1887493
RE: Changing a function to work with multiple records

TheSQLGuru (6/28/2016)
As for me, I almost always never say always, if I can help it, because there are almost always exceptions.:-P
Which is why I said "if you can help it"...
--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)

June 28, 2016 at 8:02 pm

#1887483
RE: Pie in the Sky: What's the Ultimate Share for Cloud Solutions?

jon.luers (6/28/2016)
With all the marketing focus on cloud-based solutions, I wonder what professionals think will be the end result--will practically everything end up in the cloud eventually, or how significant...
--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)

June 28, 2016 at 7:40 pm

#1887481
RE: Democratic Data Science

Steve Jones - SSC Editor (6/28/2016)
Do we need DBAs to manage backups?
Heh... I know you know better but it does bring up a point of observation. Why is...
--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)

June 28, 2016 at 7:04 pm

#1887477
RE: Democratic Data Science

Steve Jones - SSC Editor (6/28/2016)
However now most major sports, at high amateur and pro levels, use all sorts of analytics.
And, most of the time, they don't help at...
--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)

June 28, 2016 at 7:01 pm

#1887475
RE: Changing a function to work with multiple records

NHS Baz (6/28/2016)
2. What do you mean by build a box around the user and what is Halloween protection? I'm not performing any UPDATE in the function so I...
--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)

June 28, 2016 at 6:44 pm

#1887474
RE: Changing a function to work with multiple records

NHS Baz (6/28/2016)
3. What do you mean by inline the logic or convert to an inline table valued function? My function only returns a single integer value.
Please see the...
--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)

June 28, 2016 at 6:33 pm

#1887472
RE: Notification Mail without SMTP

New persopn (6/28/2016)
In that server SMTP is not enabled, We want to get the Backup report through mail using PowerShell without using SMTP. IS it possible
Yes. Please see the...
--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)

June 28, 2016 at 6:27 pm

#1887471

Viewing 15 posts - 17,341 through 17,355 (of 59,067 total)