Viewing 15 posts - 2,431 through 2,445 (of 2,769 total)
Try something like this:select * from tableA
join tableB on tableA.drug like '%' + tableB.drug1 + '%'
I think this is the correct syntax. (Someone correct me if I'm wrong.)
Also, keep...
June 23, 2010 at 2:15 pm
PaulB-TheOneAndOnly (6/23/2010)
In this particular case I'll probably go with a denormalized solution - single table.
Just curious: why single table? When I first read the question, my initial thought was...
June 23, 2010 at 8:08 am
Elgar (I'm listening to Enigma Variations right now).
(Any other classical music buffs out there?)
June 23, 2010 at 7:39 am
GilaMonster (6/22/2010)
Not exactly union, but you can insert the results of a proc into a table. Insert both result sets into a temp table, then query that.
I'm with you. ...
June 22, 2010 at 1:18 pm
CirquedeSQLeil (6/17/2010)
SpaceBalls
"I see your Schwartz is as big as mine . . . "
June 17, 2010 at 12:57 pm
CirquedeSQLeil (6/16/2010)
cats rot
Hey, careful! I own two cats!!!
(Okay, more accurately, they own me!!!)
June 16, 2010 at 9:18 am
I used dynamic SQL (within an SP) not long ago to resolve an issue I had. I was trying to use a WHERE clause, and couldn't get it to...
June 14, 2010 at 1:00 pm
Steve Jones - Editor (6/14/2010)
Now they need...
June 14, 2010 at 11:48 am
tosscrosby (6/14/2010)
Cris E (6/14/2010)
The trick, of course, will be staying healthy.
Too true! We had Mark Prior and Kerry Wood at one time here on the Cubs. Mark...
June 14, 2010 at 11:47 am
Just curious, fellow baseball fans: what are your thoughts on Stephen Strasburg?
June 14, 2010 at 8:46 am
crookj (6/11/2010)
dbowlin (6/11/2010)
Originally from Chicago. Glad they won.But still there is something fundamentally wrong with hockey in June.
Same here - Born in Chicago but left when I...
June 11, 2010 at 9:48 am
dbowlin (6/4/2010)
Ray K (6/3/2010)
Grant Fritchey (6/3/2010)
dbowlin (6/3/2010)
Ray K (5/18/2010)
Hey Dan, anything to report on this?Haven't heard from you in a while, so I was just wondering!
I am working through the...
June 10, 2010 at 10:58 am
GilaMonster (6/9/2010)
Ray K (6/9/2010)
Maybe at 868, you could have "The Story of Oh" (as in Sadaharu Oh) :hehe:Have some pity on the non-US people...
Well, Sadaharu Oh played his entire career...
June 10, 2010 at 10:51 am
winston Smith (6/10/2010)
any of you are both sql analysts/dba's and web developers, and how did you ramp up to understanding the layout of a large web app?
Yes, me! I...
June 10, 2010 at 10:35 am
Viewing 15 posts - 2,431 through 2,445 (of 2,769 total)