Thank you guys, yes I'm going to use sp_executesql, but in case I had more parameters

(e.g. dd1, dd2..etc) how can I write it then?

EXEC sp_executesql @SQLString, N'@dat1 datetime', @dd1

Yes, it was the problem, thank you!

okay I know , but not what I want ... try to apply it on my example.

again: input parameter is date:e.g. 1.3.2012

DECLARE @dat1 as datetime

DECLARE @SQLString NVARCHAR(4000)

SET @dat1 =...

Two answers.

1) you can ignore it , it is just an example

2) 'cos I will use it via MS access...

All I want to know is how to write...

I have found solution 🙂

stDocName = "GRAPH"

DoCmd.OpenForm stDocName, acFormPivotChart

Depending on the version of Access you are using, you may be able to do this without using VBA. Several questions about your situation:

1.What version (or versions) of Access are...

Thank you now it works 🙂

Have a nice day!

HI ,

If you use TotalCommander ... there is multi-rename tool and you can very easy rename all your files.

Hi, I've just tried computed columns and it works as well.

yes, you are right it is much better.

Thank you.

Not yet , but I will test it

oh yes Sergiy, thank you , btw

the procedure works properly.

Thank you, Sergiy I will try it, what does it mean BOL?

Here are 2 triggers which are applied on table.

ALTER TRIGGER Cis_OP_No_Trigger1

ON dbo.Cis_OP_No

FOR INSERT, UPDATE

AS

IF (UPDATE (N_Vyrobok) or UPDATE (N_Kplan))

update Cis_OP_No set N_Vyrobok2 = (select ( i.N_Vyrobok +...

so what would you suggest ? How to solve this problem, because I need these triggers...