Forum Replies Created
Viewing 15 posts - 1,126 through 1,140 (of 4,080 total)
-
RE: Are the posted questions getting worse?
Gail: Wow....
Lynn: Good luck, because merit doesn't always triumph in this crazy world
Jason: The "Today" show carried footage of a naked jogger today, and...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: conditional table joins
Can you explain why this is not just a simple OR ?
Asked and answered.
I would expect a "conditional join" to perform poorly.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
Steve should publish a book: "Best of The Thread" or possibly "Worst of The Thread".
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: cross join exclude data based on partial character of a data
I'm sorry to say I don't see another approach at this time.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Hypothetical Queries and Joins. AKA Why are these different?
No problem. 🙂 Craig, I learned from your explanation.
Have a great evening, guys.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Hypothetical Queries and Joins. AKA Why are these different?
Craig, I created tables A-F in my sandbox database and the queries posted would not run.
Msg 4104, Level 16, State 1, Line 10
The multi-part identifier "f.id" could not be bound.
I...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
Yet again, I will attempt to explain....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: conditional table joins
Gus:
The reason I said use CASE is that you might have cases where the join to T2 succeeds but some other T2.column value is NULL anyway.
In that...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
... and a recitation of all parameters for DBCC TIMEWARP.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Hypothetical Queries and Joins. AKA Why are these different?
Are you sure about your syntax?
Where is the join to F in either query? What are using to join to C in the second...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Geography Data Type - Best Practices
We are just expecting that the user's locations will be acceptable if they are within a range of the lat/long of the store, hence I thought using the buffer around...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Geography Data Type - Best Practices
Lisa, just this once, I will urge you to reconsider.
Queries against spatial indexes using a geography datatype will run much slower. Geography is...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: cross join exclude data based on partial character of a data
Let's call it a great team effort and cross the finish line with hands joined in victory. 😀
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: cross join exclude data based on partial character of a data
Thank you.
You are defining your course titles as NCHAR, which means they are padded with blanks on the right to the specified length. NVARCHAR might be a...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: cross join exclude data based on partial character of a data
You beat me to it, Sean.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
Viewing 15 posts - 1,126 through 1,140 (of 4,080 total)