Archive for November, 2008

SQL – Filtering WHERE condition on two rows

iStock_000005792139Medium I received the following question a couple of days ago from a programmer using the “Ask  a Question” form which you can access from the menu of this blog:

Given the following table:

Name Language
Nikhil Hindi
Nikhil English
Kisu Hindi
Kisu English
Rakesh Hindi
Kousik Bangali

How do I select names of persons who know both Hindi and English?

In this table, that query should return Nikhil and Kisu.

Read the rest of this entry »

Other Related Items:

Conker I Want You To Join The Squirrels Poster 1140Conker I Want You To Join The Squirrels Poster 1140
This is a standard size poster measuring 23 x 34 inches. All our posters are shipped in hard tubes for protection to prevent any bending or creasing during shipment.
Brand New Atrend 12sql 12" Single Sealed Car Subwoofer Enclosure with Heavy Duty 3/4" High Density Mdf (1.0 Cubic Feet Air Volume)Brand New Atrend 12sql 12" Single Sealed Car Subwoofer Enclosure with Heavy Duty 3/4" High Density Mdf (1.0 Cubic Feet Air Volume)BRAND NEW ATREND 12SQL 12" SINGLE SEALED CAR SUBWOOFER ENCLOSURE WITH HEAVY DUTY 3/4" HIGH DENSITY MDF (1.0 CUBIC FEET AIR VOLUME) Features: Single ... Read More >
The Complete Adult Psychotherapy Treatment Planner (PracticePlanners?)The Complete Adult Psychotherapy Treatment Planner (PracticePlanners?)The Complete Adult Psychotherapy Treatment Planner, Fourth Edition provides all the elements necessary to quickly and easily develop formal treatment ... Read More >

If you're new here, you may want to subscribe to the mailing list to get notifications of new post and a virtual tour of past topics. Thanks for visiting!

Renaming Properties, Methods and Variables

B03B0065 Have you ever written some code and named something one thing only to realize that it should be named something else?

If you haven’t you haven’t been programming for very long.  Maybe you started a new job and you spent two weeks writing code using your previous employer’s naming conventions only to find out that this employer expects things to be named slightly differently.

So now you not only have the item named incorrectly, but you’ve referenced it from other files, so it isn’t a simple matter of just giving it a new name.  No, the code that is referencing it has to be changed as well.  So what are you going to do?

Read the rest of this entry »

Other Related Items:

Wu-tang Clan Logo Black T-shirt TeeWu-tang Clan Logo Black T-shirt TeeWu-tang Clan blackt-shirt. Features the clan's logo. 100% cotton. Officially Licensed.
Dyno-quest: a Dinosaur Adventure! (DOS)Dyno-quest: a Dinosaur Adventure! (DOS)Go on a Dyno-Quest...where your first stop is 150 million years B.C.! The year is 3045 A.D., and technology has constructed the world's first time mac... Read More >

The Dangers of Testing as Part of an Interview

It has always struck me as an odd practice to give a written test to an interviewee during the hiring process.  I’ve been on both sides of the hiring process.  I’ve had to take a few of these tests.  My general perception is that all a test shows is that the person taking it knows how to take a test.

I’m going to approach this topic from the hiring manager’s perspective since that is the only perspective that really matters.  I could go on about how it is unfair to me as a potential employee, but that wouldn’t convince those who need to be convinced.  So here are some points to consider when considering testing as part of the process:

Read the rest of this entry »

Other Related Items:

Stanley 95-113 Mini Tripod Keychain LED FlashlightStanley 95-113 Mini Tripod Keychain LED FlashlightInnovative hands free tripod designed mini flashlight has 1 super bright white LED and has On Off switch. Includes swivel key ring and runs off replaceable batteries. Refer to model No. 392BP for replacement batteries.

Friday Books – ASP.NET 3.5 Unleashed

ASP_NET_3_5_Unleashed Product Description

ASP.NET 3.5 Unleashed is the most comprehensive book available on the Microsoft ASP.NET 3.5 Framework, covering all aspects of the ASP.NET 3.5 Framework–no matter how advanced.

This edition covers all the new features of ASP.NET 3.5. It explains Microsoft LINQ to SQL in detail. It includes a chapter on the two new data access controls introduced with the ASP.NET 3.5 Framework: ListView and DataPager. With its coverage of ASP.NET AJAX, this book shows you how to take advantage of Microsoft’s server-side AJAX framework to retrofit existing ASP.NET applications with AJAX functionality. It also demonstrates how to use Microsoft’s client-side AJAX framework to build the web applications of the future: pure client-side AJAX applications. All code samples are written in the C# programming language. (Visual Basic versions of all code samples are included on the CD-ROM that accompanies this book.)

Read the rest of this entry »

Other Related Items:

Don't Mess With Me... Programmer on Women's Cotton T-Shirt (in 22 colors)Don't Mess With Me... Programmer on Women's Cotton T-Shirt (in 22 colors)100% preshrunk heavyweight cotton; double-needle stitching throughout; seamless rib at neck; shoulder-to-shoulder tape; heather grey is 90% cotton, 10% polyester; fashion cut; 5/8" rib collar; fitted tapered sleeve.
Beginner's ASP.NET in VB.NET 2003 on DVDBeginner's ASP.NET in VB.NET 2003 on DVDASP.NET (VB.NET) 2003 represents an important technology for building enterprise level web applications. Learn the basics of ASP.NET development as yo... Read More >
MCTS Self-Paced Training Kit (Exam 70-562): Microsoft .NET Framework 3.5-ASP.NET Application Development: Microsoft(r) .Net Framework 3.5 ASP.Net Application Development (Pro - Certification)MCTS Self-Paced Training Kit (Exam 70-562): Microsoft .NET Framework 3.5-ASP.NET Application Development: Microsoft(r) .Net Framework 3.5 ASP.Net Application Development (Pro - Certification)

Ace your preparation for the skills measured by MCTS Exam 70-562—and on the job. Work at your own pace through a series of lessons and reviews... Read More >

Advantages of Using Class Diagram

misc_vol4_063 One of the new tools that showed up in Visual Studio 2005 that I don’t see many people taking much advantage of is the Class Diagram.

The class diagram displays the classes you drag onto it in a visual representation much like a UML class diagram does.  It also lets you see relationships between your classes.  But the greatest power in the Class Diagram is that it will write a lot of your code for you.

Read the rest of this entry »

Other Related Items:

BOB ROSS JOY OF PAINTING SERIES: SEASCAPE COLLECTION (13 half hour Instructional Guides)BOB ROSS JOY OF PAINTING SERIES: SEASCAPE COLLECTION (13 half hour Instructional Guides)Everything you need to know to paint Bob Ross beautiful seascapes.
Canon Vb-C60 Ptz Network CameraCanon Vb-C60 Ptz Network CameraCANON VB-C60 PTZ NETWORK CAMERA
DotNetNuke Sponsor

 

Most Valuable Blogger
Sponsor