Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,136 through 33,150 (of 59,099 total)

RE: nvarchar(100) shows length nvarchar(200) for sp_help

To add to BitBucket's answer... it takes two bytes to represent 1 character in NVARCHAR which is really "Unicode" of sorts. The first byte indicates the "country code" (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 24, 2011 at 10:44 am

#1357543
RE: Urgent: Handling [& , ' etc] in TSQL

So... enquiring minds want to know... did the latest code fix things for you or not? 😉
--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 24, 2011 at 10:09 am

#1357541
RE: At the end of my rope!

MuchLearnSoLittleTime (7/23/2011)
Wasn't trying to waste you time. Obviously there was a communicate problem. If you are so concerned about your time then why are you on this site responding to...
--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 24, 2011 at 10:06 am

#1357540
RE: selecting dataset with row numbers

VERY interesting. Thanks, Orlando, especially for the datatype match reminder.
What's really interesting (interesting as in "very odd") is that the changes to the code actually made the table variable...
--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 24, 2011 at 9:47 am

#1357538
RE: RS 2008 - Reports Spinning and Eating CPU

bddupree (7/22/2011)
OK, finally determined that this is a bug in RS 2008. Has been fixed in 2011 (Denali) according to Microsoft.
The workaround is to set the InteractiveHeight =...
--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 23, 2011 at 5:28 pm

#1357497
RE: selecting dataset with row numbers

Would you do me a favor then? Would you run my code example and post the results? I'm always curious as to what any given piece of code...
--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 23, 2011 at 5:20 pm

#1357495
RE: How to Delete Right 3 Characters from a string

Ya know, Remi... I thought you were just joking.
--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 23, 2011 at 5:12 pm

#1357489
RE: selecting dataset with row numbers

opc.three (7/23/2011)
Bah! SELECT INTO! 😀
😛
--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 23, 2011 at 3:37 pm

#1357470
RE: Urgent: Handling [& , ' etc] in TSQL

I just tried both of the following on my machine and they both work just fine. You don't need the double quotes after all. You do, however, need...
--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 23, 2011 at 3:15 pm

#1357468
RE: selecting dataset with row numbers

I don't know what others may get, but I'm seeing that a Temp Table solution is about half the CPU intensity and about 2/3'rds the duration of a Table Variable...
--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 23, 2011 at 3:00 pm

#1357466
RE: Urgent: Handling [& , ' etc] in TSQL

Sridoc2020 (7/23/2011)
Jeff,
those are not real file names, they are edited for privacy. Just they are not real. But real file names also consists these kind of characters. They are done...
--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 23, 2011 at 2:26 pm

#1357464
RE: Urgent: Handling [& , ' etc] in TSQL

Yep... I know. My apologies... Since you're doing relatively advanced work, I made the bad assumption you might know about the "REPLACE" function. Here's how to do it.
REPLACE(@FileName,...
--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 23, 2011 at 2:24 pm

#1357463
RE: need technique to find duplicates which are causing PK constraint failure during merge

hxkresl (7/22/2011)
I am merging two tables:
TBLANIMAL (as T)
animal varchar(40)
haveit bit
name varchar(30)
ANIMAL (as A)
animal varchar(40)
haveit bit
name varchar(30) Primary Key
I am merging on T.animal = A.animal. The source table (T) has...
--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 23, 2011 at 2:03 pm

#1357459
RE: Urgent: Handling [& , ' etc] in TSQL

Not quite what I had in mind. You put the double quotes on the wrong side of the single quotes. I believe you want to end up with...
--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 23, 2011 at 1:56 pm

#1357457
RE: Urgent: Handling [& , ' etc] in TSQL

{sorry, duplicate post removed}
--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 23, 2011 at 1:52 pm

#1357456

Viewing 15 posts - 33,136 through 33,150 (of 59,099 total)