selecting a column based on multiple values in SQL

Question

0.00/5 (No votes)

See more:

Hello all..

Good afternun..

In my table I have two column in a table named as batchname,process.
bachname contains the 1000 filename,process contains whether the file is completed or not.

My problem is,
I want to select the process column based on 1000 file name.
can anybody provide the query for that?How to pass the 1000 file name to get a process column for the corresponding file?

thanks in advance

Posted 9-Aug-12 23:37pm

jai_mca

Add a Solution

Comments

ssd_coolguy 10-Aug-12 5:42am

can you explain more with example..
means how batchname contains filenames?

Santhosh Kumar Jayaraman 10-Aug-12 5:44am

Can you give us one of ur record?

Santhosh Kumar Jayaraman 10-Aug-12 5:51am

i think single row have 1000 filenames like a,ab,ac,vd,fg...So a sample row will be
Batch name Process
a,ab,ac,vd,fg... Completed
Is that right?

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Andrei Straut** · Accepted Answer · 2012-08-09T23:45:00

If you know the filenames, you can try something along the lines of:

SQL

SELECT process
FROM table_name
WHERE batchname IN ('batchname1', 'batchname2,', 'batchname3', 'batchname1000');

Now, the problem is that you'll have to come up with a way to put those dynamically in the WHERE clause, writing 1000 file names would be painfully boring (not to mention the fact that they may be 10,000 tomorrow).

Wendelius · Accepted Answer · 2012-08-09T23:59:00

Not sure if I understood your question correctly, but if you have several batch names on a single row (and in a single column) and then a column describing a single process, I think you should change the design of your tables. For example to something like:

Process
- processid, primary key
- name
- status ...

Batch
- processid, foreign key to process
- name ...

*dan!sh* · Accepted Answer · 2012-08-09T23:45:00

Solution 1

If your table has 1000 rows and you need process information of 1000 batchname, you can simply select all the rows.

Otherwise you could make use of "in" clause. Although this may get messy if you put 1000 values.

Posted 9-Aug-12 23:45pm

dan!sh

Comments

jai_mca 13-Aug-12 1:23am

Thanks andrei...thanks to all.i solved the problem

selecting a column based on multiple values in SQL

3 solutions

Solution 2

Solution 3

Solution 1

Add your solution here

Preview 0