Viewing 15 posts - 1,141 through 1,155 (of 4,080 total)
Are you editing your first post? If so, please don't. Just add new posts so others can follow what is happening.
Looking at your...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 2, 2011 at 1:38 pm
I would expect a "conditional join" to perform poorly.
My suggestion would be to join to the table twice
SELECT *
FROM T1
LEFT INNER JOIN T2 ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 2, 2011 at 1:14 pm
You can test the rightmost two characters by using the RIGHT() function. In your example, try adding this to the WHERE clause.
AND RIGHT(dbo_vwCourseClass.ClassTitle,2) <> RIGHT(dbo_vwCourseClass_1.ClassTitle,2)
However, the solution above...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 2, 2011 at 10:43 am
I finally took time to find this.... just for Jason.
http://www.musicbuzzer.com/randy-newman/naked-man-video.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
June 2, 2011 at 10:31 am
Fastest performance. (One pass... No Sort Required)
with cte (RowID,A,B,C,D,E) as
(
select 1,1,2,3,4,5 union all
select 2,3,1,5,3,2 union all
select 3,7,4,1,2,5
)
,cte2 as
(select *, case when A > B...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 2, 2011 at 10:17 am
Just for fun
with cte (RowID,A,B,C,D,E) as
(select 1,1,2,3,4,5 union all
select 2,4,1,5,3,2 union all
select 3,7,4,1,2,2
)
,cte2 as
(select RowID,CA.* from cte
cross apply (values (cte.A),(cte.B),(cte.C),(cte.D),(cte.E)) CA (val)
)
...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 2, 2011 at 9:56 am
You're welcome, Doug. This may be the first time I've ever been thanked for saying "NO".
Congratulations on making it happen with dynamic SQL. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 2, 2011 at 9:41 am
The problem is that all statements are being checked against the table schema prior to the actual execution of the statements.
Simply put, the above...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 2, 2011 at 8:58 am
There are two types of people in this world.
Those who can anticipate what's coming next.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 2, 2011 at 8:43 am
SOM
Somebody remembered!
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 1, 2011 at 2:13 pm
No problem, Mike. We all have moments like 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
June 1, 2011 at 2:05 pm
It's working. You just can't see it with your print statement because you aren't trimming spaces from @X.
Try this
set @cmd = rtrim(@x) + ' '+ @y
print @cmd
P.S. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 1, 2011 at 1:33 pm
GilaMonster (6/1/2011)
DBCC RunLikeHell
DBCC MyEyesMyEyesIveGoneBlind
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 1, 2011 at 1:07 pm
May have to shut it for quite a long time too 😉
However long it takes.
Your running rhino icon looks naked, Jason.
Would you consider changing your...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 1, 2011 at 12:29 pm
Insert your random cursors where you wish, change the variables and attach speech to the output.
Shut the front door....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 1, 2011 at 11:32 am
Viewing 15 posts - 1,141 through 1,155 (of 4,080 total)