Viewing 15 posts - 376 through 390 (of 536 total)
You're welcome. Have a good weekend. 🙂
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
October 29, 2010 at 4:17 pm
Basically, an inner join forces both tables to have the same value in the columns you're using in the join.
Table1
ColomnA
1
2
3
Table2
Column A
1
2
SELECT Table1.ColumnA
FROM Table1
INNER JOIN Table2 ON Table2.ColumnA =...
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
October 29, 2010 at 3:42 pm
ms4446 (9/28/2010)
I am "Left Outer Join" becuase I really like when my queries return NULL values.
Watch out ms4446, you may be projecting 12 points ahead o' me this week, but...
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
October 29, 2010 at 9:33 am
mbender (10/28/2010)
thanks for your help, this is the SQL Newbies forum correct?
Little background on myself, i'm all self taught and new to actually writing in T-SQL. So if i'm...
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
October 28, 2010 at 3:22 pm
Steve Jones - SSC Editor (10/26/2010)
My son says this reminded him of me. Yikes.
You remind him of which one? Steve or Bill? 😀
That's really funny by the way.
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
October 26, 2010 at 3:26 pm
ChrisM@home (10/26/2010)
mtillman-921105 (10/26/2010)
Steve Jones - SSC Editor (10/26/2010)
I loved Foxpro. First SQL App I wrote was an upgrade from Fox/DOS to VFP/SQL Server. Worked great!
Good, then I'm glad I don't...
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
October 26, 2010 at 10:24 am
Steve Jones - SSC Editor (10/26/2010)
I loved Foxpro. First SQL App I wrote was an upgrade from Fox/DOS to VFP/SQL Server. Worked great!
Good, then I'm glad I don't have to...
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
October 26, 2010 at 10:12 am
WayneS (10/25/2010)
mtillman-921105 (10/25/2010)
Where I'm at right now the current system(s) are in FoxPro. It works. I'm part of the team rewriting the HR part using .NET and SQL Server, we...
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
October 26, 2010 at 9:54 am
Ray K (10/26/2010)
And I have two Giants on my office fantasy team! Those points took me over the top!
Wish I...
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
October 26, 2010 at 9:24 am
SequelSurfer (10/20/2010)
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
October 25, 2010 at 2:26 pm
Where I'm at right now the current system(s) are in FoxPro. It works. I'm part of the team rewriting the HR part using .NET and SQL Server, we redesigned. Making...
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
October 25, 2010 at 12:28 pm
Good question, thanks. 🙂
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
October 22, 2010 at 8:41 am
Tom.Thomson (10/21/2010)
mtillman-921105 (10/19/2010)
kevin.l.williams (10/19/2010)
If I saw any production code like 2, 3 or 4, the developer would get an ear full. I will stick with count(*) thank you very much.
Maybe...
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
October 21, 2010 at 8:59 am
kevin.l.williams (10/19/2010)
mtillman-921105 (10/19/2010)
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
October 19, 2010 at 12:25 pm
vk-kirov (10/19/2010)
mtillman-921105 (10/19/2010)
Oracle's even harder to use.Hmm... Are you saying this as a developer or as a DBA?
I'm saying this as a developer, but my understanding is that both are...
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
October 19, 2010 at 9:30 am
Viewing 15 posts - 376 through 390 (of 536 total)