Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,301 through 18,315 (of 59,070 total)

RE: how to loop without endless joins

First of all, apologies to Lynn Pettis. He's spot on for the solution to this problem but I missed looking at his code. Nice job for realizing 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)

February 24, 2016 at 7:46 pm

#1860946
RE: LAst date's for past 3 months

sharonsql2013 (2/24/2016)
This helped me..
SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())-n,0))
FROM (VALUES(0),(1),(2))x(n)
SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0))
SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0))
SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())-1,0))
SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())-2,0))
That's what I was afraid of. A second less than 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)

February 24, 2016 at 6:48 pm

#1860944
RE: LAst date's for past 3 months

MMartin1 (2/24/2016)
sharonsql2013 (2/23/2016)
How can I show last days for past 3 months say..
Jan 2016 (2016-01-31 23:59:59.000)
, Dec 2015
and Nov. 2015
Need to be dynamic as it will change...
--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)

February 24, 2016 at 6:36 pm

#1860942
RE: how to loop without endless joins

Sean Lange (2/24/2016)
I don't understand the logic here. Can you try to explain what you are trying to do?
It's an adjacency list and he simply wants to display the adjacency...
--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)

February 24, 2016 at 4:53 pm

#1860931
RE: Are the posted questions getting worse?

SQLRNNR (2/24/2016)
GilaMonster (2/24/2016)
SQLRNNR (2/24/2016)
GilaMonster (2/24/2016)
jasona.work (2/24/2016)
http://www.sqlservercentral.com/Forums/Topic1763775-3412-1.aspx
/Me leans back, grabs bucket of popcorn
Sure sounds like Gail answered the original question, yet for some reason the OP decided to focus on 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)

February 24, 2016 at 2:51 pm

#1860907
RE: partitioning

bark stuff (2/24/2016)
You need to read questions properly before answering. Three times I stated the question and three times you have gone off on a tangent.
Heh... you should...
--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)

February 24, 2016 at 2:19 pm

#1860898
RE: How to find account number of bank from given records in table

MMartin1 (2/24/2016)
We cannot use extra columns in file.
Maybe the person or persons that made this decision and decided to put you as the implementer should take on the task themselves....
--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)

February 24, 2016 at 1:31 pm

#1860878
RE: Does a tool like "SQL Agent Compare" exist?

pg 93049 (2/24/2016)
Apologies for replying to an old post but for the benefit of anyone looking for a tool to compare configuration settings (inc. jobs). You can use the beta...
--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)

February 24, 2016 at 1:28 pm

#1860876
RE: How to find account number of bank from given records in table

I definitely wouldn't use XML for anything even close to this. Also, computers don't "easily" read XML. There are programs that make it easy for Developers to incorporate...
--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)

February 24, 2016 at 8:22 am

#1860741
RE: How to find account number of bank from given records in table

Please identify the banks you're doing this for so we can make sure that none of us will be affected by 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)

February 23, 2016 at 3:13 pm

#1860581
RE: Using Parameters in a Query is Killing Performance

Sergiy (2/23/2016)
Loner (2/19/2016)
As I said before, the database is created from the software company, I cannot create any index.
When a faulty part or design fault is discovered in certain model...
--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)

February 23, 2016 at 3:10 pm

#1860579
RE: LAst date's for past 3 months

sharonsql2013 (2/23/2016)
Just past 3 months. I am not building a table
Two way street here, Sharon... please post the code you ended 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)

February 23, 2016 at 3:07 pm

#1860578
RE: Career in SQL

Luis Cazares (2/23/2016)
As long as you use the certification as a way to learn, it could help you. However, most people won't hire you just by having a certification, 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)

February 23, 2016 at 1:13 pm

#1860552
RE: Are the posted questions getting worse?

Sean Lange (2/23/2016)
Alan.B (2/23/2016)
I don't know if anyone is aware of this but I noticed Dwain Camps hadn't posted anything in awhile so I checked his blog (dwaincsql.com), simple-talk, twitter,...
--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)

February 23, 2016 at 12:27 pm

#1860533
RE: Identifying last backup and restoring to QA

ramana3327 (2/23/2016)
I am getting some issue with linked servers.
I can see the linked server is created and when I tested it is working fine.
But when I tried to run 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)

February 23, 2016 at 12:22 pm

#1860530

Viewing 15 posts - 18,301 through 18,315 (of 59,070 total)