Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,371 through 17,385 (of 59,102 total)

RE: Concatenate strings

ScottPletcher (7/1/2016)
So if a column changes from non-unicode to unicode, you're going to insist that all existing code be changed to explicitly specify unicode strings for that column?
Actually, yes. ...
--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)

July 1, 2016 at 5:29 pm

#1888177
RE: Decreasing a value across multiple rows until 0

Since this is 2016, seems like a Lead or Lag would be the way to do this.
--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)

July 1, 2016 at 3:47 pm

#1888172
RE: Concatenate strings

ScottPletcher (7/1/2016)
I still say don't explicitly code it unless the code requires it (some system procs require unicode strings specifically, for example), because it can cause performance errors or...
--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)

July 1, 2016 at 10:50 am

#1888127
RE: Concatenate strings

Agreed... and the catch here is that if this happens, what else could happen? If you use the "N" prefix for the literals whenever NVARCHAR is used, it's pretty...
--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)

July 1, 2016 at 9:27 am

#1888119
RE: Concatenate strings

Sergiy (6/30/2016)
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. ...
--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)

July 1, 2016 at 7:36 am

#1888089
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

Viewing 15 posts - 17,371 through 17,385 (of 59,102 total)