hi!

to any other noobs around here...the solution.:-D :

update dbo.analisis

set idegrupoana = '10'

where (matid = 'am') and (tipaid = 'mt')and(idegrupoana is NULL)and

(anadesc like '%disuelto%')

it worked like a...

benyos (9/9/2009)

---

That means:

1. You are inserting new records

2. You specify values for the new records so they match certain...

benyos (9/9/2009)

---

Not sure what you're trying to do here...

You have an "insert...values..." command and then "select...where..."

What are you trying to achieve? Do you mean to update records that correspond...

benyos (9/9/2009)

---

Assuming your target table is called TargetTable, your code should look something like this:

INSERT TargetTable (anadesc,idenvaseana,idegrupoana,matid,tipaid)

select anadesc,idenvaseana,idegrupoana,matid,tipaid

from dbo.analisis

where (anadesc like '%disuelto%') and (matid = 'am') and (tipaid =...

thanks.

i will read it.

Dave Ballantyne (9/7/2009)

---

OK....

Take For instance

1 2 3

-----------------

15 5280 96828810

16 5280 96828810

What output are you expecting

96828810 15,16

96828810 15

96828810 ...

Dave Ballantyne (9/7/2009)

---

Here's a simple distinct example..

create table x

(

x1 integer,

x2 integer

)

go

insert into x

select 1,0

union all

select 1,0

go

select * from x

go

select distinct x1,x2 from x

Im not sure im clear on your requirements...

thanks for the help guys.

Now another thing...

the triggers does what is supposed to...but one of the rows is PK, so the trigger cant insert the data from inserted in...

thanks!! i corrected it, it didnt work also...it i´m gonna do it all over again.

it says syntax error.

create trigger one on dbo.pedidos

after insert as

begin

set nocount on;

INSERT INTO dbo.pedidos(PedNum,ESTID)

select(inserted.PedNum,'2')

from inserted

end

dont know what i´m missing.

GSquared (8/31/2009)

---

If I understand you correctly, you want to check if there are two rows in the inserted table that have a specific value in one column. Is that...