Viewing 15 posts - 256 through 270 (of 1,228 total)
Sean Lange (2/6/2014)
ChrisM@home (2/6/2014)
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
February 6, 2014 at 1:12 pm
How are you choosing index 2 over index1?
Why would you choose index 2 over index1?
What happens when you run each query two or three times?
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
February 6, 2014 at 1:07 pm
jayoub (2/6/2014)
... if the number match up ...
What do you mean by this, Jeff? Match up with what exactly?
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
February 6, 2014 at 1:03 pm
Hey Luis I don't know if you can see what I've just seen on this funny little mobly but you my friend may just be the first! Whether you are...
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
February 6, 2014 at 12:54 pm
Any time. Have a look at LIKE in Books Online when you get the time, it's tremendously useful.
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
February 5, 2014 at 12:35 pm
Use NOT IN ().
Why are you using LIKE?
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
February 5, 2014 at 11:40 am
Post the actual execution plan as a .sqlplan attachment - there may be scope gor optimisation that you've missed.
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
February 3, 2014 at 1:24 pm
p.swathi4 (2/3/2014)
QUERY:
SELECT top * from [Servername].[WH_SYSTEM].[dbo].T_ENCOUNTER_PHYSICIAN
WHERE PhysicianID LIKE '[0-9]%'
Output:
Msg 7357,Level 16, State 2, Line 1
Cannot process...
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
February 3, 2014 at 10:13 am
p.swathi4 (2/3/2014)
QUERY:
SELECT top * from [Servername].[WH_SYSTEM].[dbo].T_ENCOUNTER_PHYSICIAN
WHERE PhysicianID LIKE '[0-9]%'
Output:
Msg 7357,Level 16, State 2, Line 1
Cannot...
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
February 3, 2014 at 10:10 am
Try this. The results are very close to your desired results set, and I can't tell if it's because the arithmetic in the query requires modification or if the desired...
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
February 2, 2014 at 11:48 am
Michael Meierruth (2/2/2014)
Jeff Moden (2/1/2014)
There is a method that'll blow the doors off of even LAG but a lot of people are afraid of it.
Thus are you referrring to CROSS...
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
February 2, 2014 at 4:24 am
Jeff Moden (2/1/2014)
Your requirements are a bit difficult to understand ...
Exceptionally difficult. Extending Jeff's request for clarification, here's a stab at something which may help to describe the problem.
SELECT
CASE...
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
February 2, 2014 at 4:04 am
asita (2/1/2014)
Hello could anybody please assist with thisThank you in advance
Please
Can you confirm which version of SQL Server you are using? Your code fails with an error (Ambiguous column name...
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
February 2, 2014 at 3:32 am
peerless (2/1/2014)
...What should I do?
You should investigate the results from the SELECT part of your INSERT query, not just this time, but every time. The same applies to UPDATEs and...
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
February 2, 2014 at 3:25 am
-- always check the equivalent SELECT is returning an appropriate result set
SELECT a.ID, b1.ID, b2.ID,
FLAGB1 = CASE WHEN b1.ID IS NULL THEN 'N' ELSE 'Y' END,
FLAGB2 = CASE...
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
February 1, 2014 at 3:53 am
Viewing 15 posts - 256 through 270 (of 1,228 total)