Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,626 through 11,640 (of 59,102 total)

RE: please help !! Dynamic SQL

Step 2 is to realize that you can't use GO in a variable that you're going to execute.
--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)

August 6, 2018 at 7:14 pm

#2000530
RE: please help !! Dynamic SQL

Lidou123 - Monday, August 6, 2018 6:22 PM
Hi experts
Please I REALLY NEED YOUR HELP !!
I want to create a dynamic sql in...
--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)

August 6, 2018 at 7:13 pm

#2000529
RE: Rows into dynamic columns

Yes. Start at the following article.
http://www.sqlservercentral.com/articles/Crosstab/65048/
If you'd like some more detailed help at the code level, then please see the article at the first link...
--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)

August 6, 2018 at 6:50 pm

#2000528
RE: BCP Error

EMtwo - Monday, August 6, 2018 5:03 PM
So far it appears that the user has permissions on the files in the directory.
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)

August 6, 2018 at 6:45 pm

#2000527
RE: SQL Database Documentation

Charles_P - Sunday, August 5, 2018 8:39 PM
We have a situation where the Lead SQL Developer is leaving the company and he...
--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)

August 6, 2018 at 6:36 pm

#2000526
RE: Delete and shrink data file

WhiteLotus - Sunday, August 5, 2018 7:24 PM
Hi guys
I just deleted a lot of rows in a table to gain more...
--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)

August 6, 2018 at 10:53 am

#2000462
RE: how to one-way encode sensitive data for display?

ScottPletcher - Monday, August 6, 2018 10:12 AM
And for all decency's sake, whatever you do, don't name the column "SSN". 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)

August 6, 2018 at 10:47 am

#2000458
RE: how to one-way encode sensitive data for display?

Eirikur Eiriksson - Monday, August 6, 2018 8:58 AM
Jeff Moden - Monday, August 6, 2018 8:46 AM
--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)

August 6, 2018 at 9:52 am

#2000446
RE: Time Outs!!

nighthawkk - Monday, August 6, 2018 9:13 AM
I'm looking into the above now, I'm essentially walking into the db with-out any of...
--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)

August 6, 2018 at 9:42 am

#2000438
RE: how to one-way encode sensitive data for display?

ScottPletcher - Monday, August 6, 2018 8:14 AM
Jeff Moden - Monday, August 6, 2018 8:00 AM
--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)

August 6, 2018 at 8:46 am

#2000424
RE: how to one-way encode sensitive data for display?

autoexcrement - Monday, August 6, 2018 8:23 AM
I still just don't fully understand how salts and the like are supposedly so helpful,...
--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)

August 6, 2018 at 8:45 am

#2000423
RE: how to one-way encode sensitive data for display?

ScottPletcher - Monday, August 6, 2018 7:43 AM
For storing of SSN, you might consider adding a check digit to the value, so...
--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)

August 6, 2018 at 8:00 am

#2000416
RE: Will Terminators Be Required?

Dan Guzman-481633 - Monday, August 6, 2018 6:21 AM
Although not using semi-colon statement terminators has been deprecated for a decade, using
--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)

August 6, 2018 at 7:25 am

#2000411
RE: Index fragmentation - performance within application context

Grant Fritchey - Monday, August 6, 2018 6:21 AM
The issue is, defragmentation leads to refragmentation. To really evaluate if defragmentation on 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)

August 6, 2018 at 6:39 am

#2000404
RE: Capture the required stored stored procedures to execute

Jonathan AC Roberts - Monday, August 6, 2018 6:05 AM
Another thing you could do, provided your database isn't really busy and 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)

August 6, 2018 at 6:24 am

#2000401

Viewing 15 posts - 11,626 through 11,640 (of 59,102 total)