Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,406 through 18,420 (of 59,070 total)

RE: How to extract overlapping date ranges from a table of date ranges

stig.benning (2/13/2016)
Hi Jeff, Thanks for the links and your suggestion. And for solving my problem 🙂 Stig
You bet. Thank you very much 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)

February 13, 2016 at 12:37 pm

#1858605
RE: How do we get the definition of tables via sql

J Livingston SQL (2/13/2016)
Jeff Moden (2/13/2016)
mw112009 (2/12/2016)
Jeff M
What we need is to be able to do via T-SQL and also we need to get the def for all tables (...
--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 13, 2016 at 10:25 am

#1858594
RE: How do we get the definition of tables via sql

mw112009 (2/12/2016)
Jeff M
What we need is to be able to do via T-SQL and also we need to get the def for all tables ( Not just picking one at...
--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 13, 2016 at 9:39 am

#1858587
RE: restore data (not all) from a backup FILE

Darryl Wilson (2/12/2016)
Hi, this may not be in the roght forum.
I have huge backup files (18gb) but I am required to retrieve data from a certain date. so I have...
--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 12, 2016 at 9:15 pm

#1858558
RE: import data from an excel to sql server

If you want to preserve the presence of leading zeros, don't import the data as any form of numeric. Import it as some form of string.
--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 12, 2016 at 9:02 pm

#1858557
RE: DBA -tasks and solutions

Having just been through a bit of a reindexing nightmare, I urge extreme caution. Non-clustered indexes are a bit of a pain in that they usually not in 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 12, 2016 at 8:58 pm

#1858555
RE: How to extract overlapping date ranges from a table of date ranges

stig.benning (2/12/2016)
Thanks a lot. Works like a dream. I mark this as the solution because I can apply it directly to my subscription table. Now I just have to go...
--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 12, 2016 at 8:34 pm

#1858552
RE: Join & Update

Hugo Kornelis (2/12/2016)
I disagree with Grumpy's first suggestion. Oracle may not "need" the AS for a table alias (and neither does SQL Server), but including it in my opinion greatly...
--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 12, 2016 at 8:12 pm

#1858550
RE: Join & Update

rshukis10 (2/12/2016)
Yes - just found this out as well
So now I'm trying to work with this:
UPDATE FGMULTI
JOIN
arinvt ar ON
...
--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 12, 2016 at 8:08 pm

#1858549
RE: Are the posted questions getting worse?

Ed Wagner (2/12/2016)
Lynn Pettis (2/12/2016)
Grumpy DBA (2/12/2016)
We will be transitioning to "mountain time". Wake up, breakfast, try to get first chair, snowboard/ski until hungry, grab a quick bite, snowboard/ski...
--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 12, 2016 at 8:02 pm

#1858548
RE: Help to optimize a SP

SQL!$@w$0ME (2/12/2016)
Thanks, Please see the actual plan attached.
It would appear that you have no data in the leading table. The actual execution plan isn't going to indicate much.
--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 12, 2016 at 7:57 pm

#1858547
RE: The Push to Upgrade from SQL Server 2005

Ironically and, perhaps shamefully, the really cool thing about 2005 is that you don't have to worry any longer about MS breaking something with a CU or SP. ...
--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 12, 2016 at 7:49 pm

#1858545
RE: overlap query where to and from can be same ( of next and previous range)

rajemessage 14195 (2/12/2016)
[font="Arial Black"]i want all records from #t
which are overlaping with entered @pointfrom = 2 and @pointTo = 10[/font]
--requirement is "f" can > or = to previous "range's...
--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 12, 2016 at 7:14 pm

#1858542
RE: How do we get the definition of tables via sql

Phil Parkin (2/12/2016)
mw112009 (2/12/2016)
Reply to Post #1760966 from Lynn
The answer is "YES" ( I mean I am able to modify the code )
Why do I need the code ?
I have...
--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 12, 2016 at 6:23 pm

#1858537
RE: Window function to expand row into multiple rows?

Jacob Wilkins (2/12/2016)
Luis Cazares (2/12/2016)
Jacob Wilkins (2/12/2016)
No need to use window functions. A simple CROSS APPLY will do the trick.
SELECT [OrderNumber]=OrderID,
[User]=x.[User]
FROM ...
--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 12, 2016 at 6:13 pm

#1858536

Viewing 15 posts - 18,406 through 18,420 (of 59,070 total)