I have a table for example: tb1
with data:
cse-12m
cse-343k
cse-mka
cse-ptu
cse-jpy

How can I write a SELECT statement to retrieve data in one of these formats:
1) cse-three digits number

How about "part1", "part3" are retrieved from SELECT statement? to use "select from table where component in (select part1 from....)"?
Also "IN(part1, part3)" is OR , not AND, right? I need "AND".

I have one table in this format:

Product Component
---------------------------
A part1
A part2
B part1
B part4
A part3
C ...

I have a table in MS SQL DB, the data was recorded with redundancy, is there an easy way to remove all but keep only one, for example:

id name age dept
---------------------------
1 ...

I am currently using MS SQL 2000 server as backend database for web site (written in php), now plan to switch DB to MS SQL 2008 Express, I have questions about this conversion:
1) Will MSSQL2008...

I use MSSQL 2000 version.
Thank you tesuji, here is the table I need to remove duplicate records.
Table "addonitems":
partid componentid quantity revision componentrevision note...

I have a MSSQL table that contains lots of duplicate records, is there a simple way to keep only one and remove all other duplicates?

mike M 60
mike M 60
mike M 60


I need only one record
...

product transaction date
--------------------------------------
1 06/07/2006
2 06/05/2006
2 06/10/2006
3 06/09/2006

I have a table like above, now I want to retrieve the latest transaction...

Thank you very much for pointing it out, I was confused.

When I try to use MS SQL Server Enterprise Manager to create table, I typed column name, data type as "int", however the length of "int" is 4, that is fixed I cannot change, now the problem is I need...

I have a question about the possible string match in sql statement, for example I have variable "$val=abc", I can write:

SELECT * FROM table WHERE field like '%$val%'

this will list all...

thank you very much for the answer!

In MSSQL "SQL server enterprise manager"(client side), I run query and application display record list, if I want to set a cell to "<NULL>" value, how can I do that with the hot key? thanks for any...

anyone can help me?

Hi,

I am in the process of deciding the database and application language.
We have exising MS SQL server running on windows OS, to save the company's product data, right now I need to build...