got it !!!

COT is a reserved word!!!!!!

thanks!

I needed an answer like that.

Alexander Suprun (6/20/2012)

---

select SUM(a.t),p

from @table3 a

where exists

(

select n

from @table3 t

where (p = 1 or...

Thanks for the reply david but it didn´t come out what i expected.

For the record i´ve managerd to get the results as i want but i think that maybe...

Thanks to everyone. Your input really help me into find the solution.

Lowell (12/19/2011)

---

i'm guessing nwdetcot is a list of all possible prices, possibly for all products thru the begfinning of time..i'm betting you need to limit it to just the...

That clears it all!

thanks!

thanks it worked.!

Now,..can...

hi!.

Since i am getting a sintax error i thought that no other info was needed.

But if...

Sendmail will send ONE email for each client (@client, cliente) with a valid email (@correocliente,correocliente).Also it will send one email to each salesperson notifying them that exist a record for...

Thanks jeff!!

i´ve been testing all week and i finally got what i needed.

I will post it tomorrow and hopefully you and some others will give me your advices to...

I appreciate all your advices and your answer.

I´ve changed the data type of the columns:

CREATE TABLE [dbo].[correosaclientes](

[cliente] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AI NOT NULL,

[ningreso] [int] NOT NULL,

[proyecto] [char](100) COLLATE Modern_Spanish_CI_AS NULL,

[fingreso]...

Thanks lowell!! i was missing the replace function!!

i got this

alter TRIGGER enviacorreos on infarchivo

for insert

AS

declare @infanlab int

declare @infanmuestra char(13)

declare @infaobs ...

thanks! that...

thanks for the input.

the software is made by the IT team of the company where i work.

i have a new problem with the following code.

create TRIGGER trgAfterInsert ON eicanalesres

FOR...