Viewing 15 posts - 1,666 through 1,680 (of 4,080 total)
???
Paul, I think you overlooked this from AJ's post in midstream.
Hi, yes I'm aware that this is not a numeric comparison. I guess my simplistic example was off the mark.
The...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 1, 2010 at 8:41 am
From the "About The Author" section.
Eric is active in the local SQL Server Community, serving as the president of the Colorado Springs SQL Server Users Group.
Copyright 2007 TechTarget
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1280004,00.html ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 1, 2010 at 8:35 am
I hope you found your way to a satisfactory solution.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 1, 2010 at 7:39 am
Thanks for taking the time to send in your actual data. Plug those values into my example(s) above and you should see exactly what is happening.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 1, 2010 at 7:30 am
The problem is about to go away. See Steve's Editorial for April 1, 2010.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 1, 2010 at 7:28 am
Oh, and what is the capacity of your tempdb database? Have you checked it for IO stalls? If you, like so many of my clients, has an under-powered tempdb storage...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 1, 2010 at 1:44 am
Whups.... there goes ROW_NUMBER(). Perhaps a temp table with an identity column to set up the variable number of columns in the result set? ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 1, 2010 at 1:19 am
How you can keep a "straight face" while writing is brilliant, Steve. 🙂
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 31, 2010 at 10:41 pm
I didn't say *I* was going to sue you. I was encouraging STEVE to. 😉
Excuse us, AJ... private joke.
I still think greater than or equal to...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 31, 2010 at 10:29 pm
Anything for you, Jason, you copyright-violator, you.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 31, 2010 at 10:03 pm
FROM BOL:
Wildcards used without LIKE are interpreted as constants instead of as a pattern, that is they represent only their own values.
http://msdn.microsoft.com/en-us/library/ms187489%28v=SQL.100%29.aspx
With respect to Glenn, this is nothing like 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
March 31, 2010 at 9:57 pm
I agree with Michael:
Wildcards only work with the LIKE operator, not >= or <=
In your example the numbers are varchar datatyped, not numeric. To find 10,20,30,40,50,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 31, 2010 at 9:27 pm
Amended, with apologies to anyone who read the first draft.
It's a rounding error (of sorts) assuming the IDs are integers.
create table emp1 (id int)
create table emp2 (id int)
insert into emp1
select...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 31, 2010 at 8:39 pm
My guess would be "rounding". Post up your table definitions and your data and we can prove or disprove 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
March 31, 2010 at 8:30 pm
select emp1.id
from emp1,emp2
Yes, this format produces an implicit CROSS JOIN of the two tables, resulting in a cartesian product. Even though you are only requesting that one...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 31, 2010 at 8:14 pm
Viewing 15 posts - 1,666 through 1,680 (of 4,080 total)