Forum Replies Created
Viewing 15 posts - 1 through 15 (of 416 total)
-
Reply To: Complex Join
At least I know it's not something trivial that I overlooked.
-
Reply To: Complex Join
/*
drop table leftTable;
drop table rightTable;
*/
create table leftTable (C1 int, C2 int, C3 varchar(20));
create table rightTable (C1 int, C2 int, C3 varchar(20));
insert into leftTable values (1, 1, 'leftTable... -
Reply To: Complex Join
It's not what is expected, and the data condition won't occur. Each column is null-able, but both cannot be null.
-
Reply To: Complex Join
Yes, that would be true.
-
Reply To: Complex Join
Unfortunately, either column can be null in one table and not null in the other. When I said "related by," I didn't mean to imply that there's an FK relationship. ...
-
RE: Today's Random Word!
crookj (5/17/2016)
djj (5/17/2016)
Ed Wagner (5/17/2016)
ThomasRushton (5/17/2016)
Ed Wagner (5/17/2016)
BWFC (5/17/2016)
Ed Wagner (5/17/2016)
Alan.B (5/16/2016)
Manic Star (5/16/2016)
crookj (5/16/2016)
Hugo Kornelis (5/16/2016)
Revenant (5/16/2016)
HappyGeek (5/16/2016)
Grumpy DBA (5/16/2016)
djj (5/16/2016)
PenaltyShot
Goal
Stretch
Limo
Limbo
Chiropractor
Bill
Gates
Pearly
Whites
Yolks
Emulsifier
Blend
Amalgam
Filling
-
RE: Today's Random Word!
whereisSQL? (5/16/2016)
djj (5/16/2016)
Ray K (5/16/2016)
crookj (5/16/2016)
Ed Wagner (5/16/2016)
Grumpy DBA (5/16/2016)
Ed Wagner (5/16/2016)
djj (5/16/2016)
ForkRoad
(less) Traveled
Scholar
Intellectual
Academic
Academy
Award
Points
-
RE: Today's Random Word!
djj (5/13/2016)
Ed Wagner (5/13/2016)
Ray K (5/13/2016)
Grumpy DBA (5/13/2016)
ThomasRushton (5/13/2016)
MechanicMike (and the Mechanics... a bit of a stretch)
Rutherford (I liked Mike + The Mechanics!)
Race
Arms
Legs
-
RE: Today's Random Word!
Ed Wagner (5/12/2016)
djj (5/12/2016)
Revenant (5/12/2016)
Ed Wagner (5/12/2016)
yb751 (5/12/2016)
Luis Cazares (5/12/2016)
crookj (5/12/2016)
ThomasRushton (5/12/2016)
Ed Wagner (5/12/2016)
Grumpy DBA (5/12/2016)
whereisSQL? (5/11/2016)
Ed Wagner (5/11/2016)
HogwartsDementor
Azkaban
Sirius Black
Dog star
Lassie
Rin Tin Tin
German Shepherd
Bichon Frise
Cute
Kitten
The Expert (https://www.youtube.com/watch?v=BKorP55Aqvg) :-D:-D:-D
Engineer
-
RE: Today's Random Word!
Ed Wagner (5/11/2016)
Hugo Kornelis (5/11/2016)
Grumpy DBA (5/11/2016)
djj (5/11/2016)
FriedBrain
Dead
Quick
Fox
-
RE: Today's Random Word!
crookj (5/9/2016)
Eric M Russell (5/9/2016)
whereisSQL? (5/6/2016)
Ed Wagner (5/6/2016)
Eric M Russell (5/6/2016)
djj (5/6/2016)
Grumpy DBA (5/6/2016)
ZZartin (5/6/2016)
Ed Wagner (5/6/2016)
StealPlunder
Pirate
Ship
Cruise
Missile
Launch
Haunch
Hunkers
Huddle
-
RE: Padding a string with extra 0's
tarr94 (5/6/2016)
Thank you for the responses! I'll give this a try. Looks like the solution might have been simpler than I had expected.I've updated my original post to...
-
RE: Padding a string with extra 0's
Jacob Wilkins (5/6/2016)
This is the sort of thing I would avoid doing at the database layer if possible+1
Definitely agree.
-
RE: Padding a string with extra 0's
tarr94 (5/6/2016)
Hello,I'll start with my sample table data.
...I'm trying to figure out how I can retrieve a string that concatenates the OrderNumber, PurchaseDate, and CustomerNumber into one string....
-
RE: Today's Random Word!
Ray K (5/6/2016)
Ed Wagner (5/6/2016)
MultiplicationDivision
Integration
Viewing 15 posts - 1 through 15 (of 416 total)