Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,581 through 17,595 (of 59,102 total)

RE: Calculate time difference based on condition - SQL Server

subramanian.esakkimuthu 40485 (6/2/2016)
you got the answer or you are still looking for the answer
Please use the other thread that JLS provided. This one is a duplicate..
--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 2, 2016 at 7:16 pm

#1882973
RE: How to place a file into a file directory.

hoseam (6/2/2016)
Hi
I have this code, which is just a part of my code:
SET @Attachment = @FilePath + @ReportFileName
SELECT
@SQLCommand = 'BCP "SELECT * FROM ##!TableName!" QUERYOUT ' +
@FilePath +...
--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 2, 2016 at 7:07 pm

#1882972
RE: Get date range of last quarter

Lynn Pettis (6/2/2016)
The following should help:
d e c la r e -- spaced to post from work
@ThisDate date = getdate();
select
@ThisDate,
...
--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 2, 2016 at 6:55 pm

#1882970
RE: More than a two-part column name - Depricated Features

gideon_king (6/2/2016)
Question: Why on earth would Microsoft (or anyone) care? What possible harm could it be doing?
Grant's supposition on the subject seems the most likely reason from a Microsoft...
--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 2, 2016 at 6:49 pm

#1882968
RE: Temp DB filling on simple update statement?

krypto69 (5/25/2016)
Hi,
I have a pretty simple update statement:
So is it fixed now???
--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 2, 2016 at 6:20 pm

#1882967
RE: Great Developers

mjh 45389 (6/1/2016)
manie (5/31/2016)
Jeff Moden (5/31/2016)
manie (5/31/2016)
I am telling you everywhere I went they ask for my qualifications and when I say I have none, they say sorry sir.
Did they...
--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 2, 2016 at 9:04 am

#1882856
RE: Need help in writing query to show data from rows into columns

ramineni.suresh661 (6/2/2016)
Thank you very much Eirikur Eiriksson , your Quick suggestion made my day . you deserve a round of applause
The question now is... do you understand how it works...
--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 2, 2016 at 6:56 am

#1882803
RE: An IDENTITY column has reached Max int

DesNorton (5/30/2016)
Hi Jeff
Something went awry with your quote. Somehow the OP text was quoted under my name
That happens if one waits a bit, someone else posts, and then 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)

June 2, 2016 at 6:46 am

#1882800
RE: SQL WHERE and SELECT portion of character string after defined text

You bet. Thank you 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)

June 1, 2016 at 8:46 pm

#1882704
RE: Can we just lock the schema rather a DB?

Steve Jones - SSC Editor (6/1/2016)
Well, I'd want to know why, but the only way I know to do this (Easily) is use roles for all permissions and then remove...
--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 1, 2016 at 8:37 pm

#1882701
RE: SQL WHERE and SELECT portion of character string after defined text

The comments in the code explain it. Remember that you don't have to calculate the length of the substring for things like this. SQL Server will do that...
--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 1, 2016 at 8:19 pm

#1882696
RE: DBCC CHECKDB JOB STOPPED EXECUTION

coolchaitu (6/1/2016)
The job actualy runs a Powershell script that does DBCC CHECK on all databases. The output log just says "Maintenance completed with errors".Thats it, there is no other information...
--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 1, 2016 at 8:02 pm

#1882694
RE: Need help in t-sql query

neela.teki (6/1/2016)
Yes drew.allen. I also considered the scenario where customer started with one emailaddress and changed to couple more different emailaddreses and changed back to same emailaddress he/she started 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)

June 1, 2016 at 7:58 pm

#1882693
RE: Can we just lock the schema rather a DB?

Steve Jones - SSC Editor (6/1/2016)
Not sure that's a lock. It's a login/use restriction, maybe technically a lock, but you haven't used any locking to process data there. Certainly 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 1, 2016 at 5:42 pm

#1882687
RE: Logon trigger rejects connections when CPU use is high

When you get this fixed to some level of satisfaction, you'll need to starting working on the real problem and that's to find out and fix what has your server...
--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 1, 2016 at 5:40 pm

#1882685

Viewing 15 posts - 17,581 through 17,595 (of 59,102 total)