It's not problem to write stored procedure but later I need rto select some values from....(function)

I tried that but I can't execute stored procedure inside a function?

How to solve that?

THanks, Jelena

Thanks,

I know it can be done in EM, but I thought to make that in code.I read it can not be done in code...

Jelena

I am not sure it is so simply....

Jelena

CREATE TRIGGER .... ON [dbo].[...]

FOR INSERT

AS

DECLARE @AccTransCode varchar(10)

--triger insertuje u tabelu AccTransaction izvrsena narocila (prodaje)

DECLARE @TransactionID int

DECLARE @TransactionIDNew int

DECLARE @BuyerReference varchar(10)

DECLARE @SellerReference varchar(10)

IF UPDATE(BuyerReference) and UPDATE(SellerReference)

BEGIN

EXEC GetNextIdentity 'AccTransaction'...

CREATE TRIGGER .... ON [dbo].[...]

FOR INSERT

AS

DECLARE @AccTransCode varchar(10)

--triger insertuje u tabelu AccTransaction izvrsena narocila (prodaje)

DECLARE @TransactionID int

DECLARE @TransactionIDNew int

DECLARE @BuyerReference varchar(10)

DECLARE @SellerReference varchar(10)

IF UPDATE(BuyerReference) and UPDATE(SellerReference)

BEGIN

EXEC GetNextIdentity 'AccTransaction'...

The data arrive in .txt format, but my problem is how to connect client every day to that internet adress and download file?

I think there wili be no problem to...

When I update options on Sql Server it doesn't affect to default options.After aplication connection I always have:

set quoted_identifier on

set implicit_transactions off

set cursor_close_on_commit off

set ansi_warnings on

set ansi_padding on

set ansi_nulls on

set...

Thanks,but I still can't see letters è and æ, instead I always see c.

Jelena