Help us help you.

Please read this Page

http://www.aspfaq.com/etiquette.asp?id=5006

This will work, but I would explicitly define the Update, and Delete triggers separately.

Then you know the action by the type of trigger that is firing. You are not saving...

Right here your adding the @test-2 parameter to your cmdsave object twice. The stored procedure only has 1 @test-2 Parameter.

cmdSave.Parameters.Add("@test", TextBox1.Text)

cmdSave.Parameters.Add("@test", TextBox2.Text)

Are you...

Comeon dude, a little more attention to detail

-- select @SqlString

exec sp_executeSql @SqlString, N'@FieldID int, @EventID int', @FieldID, @EventID

Try changing to varchar(500).

if your doing the

cmdSave.Parameters.Add("@test", TextBox1.Text)

cmdSave.Parameters.Add("@test", TextBox2.Text)

in the same database call, your adding duplicate @test-2 parameters to the stored procedure.

Please post the stored procedure you have created.

http://www.aspfaq.com/etiquette.asp?id=5006

How bout you declare the variable to use the datatype you want. Here you declare it as int.

-- Stored procedure chtobi otobrazit XML s FieldName kak ElementName

DECLARE @SqlString nvarchar(4000)

DECLARE @FieldID...

In addition, is there en etiquette post that can be put as sticky, or that we can use as a response for inadequately formed questions?

I don't think the problem is necessarily ODBC.

I have seen this problem before but was unable to specifically find the issue with the stored procedure. You need to evaluate...

Almost

When you declare variables in dynamic sql the second parameter is a string indicating all in string variables, then a comma separated list of input values.

-- Berem obe stroki i...

you want to query records from the tables by userId?

if so.

CREATE FINAL_PROCEDURE

(@UserID int)

Edit this part

-- Uzaem Dynamic Sql chtobi sozdat stroku dlya execute.

-- Sozdaem Pivot Table stroku that has the...

Dude, You seriously need to do some research on datatypes.

Text data type is very difficult to work with, and what your doing will result in data loss.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_nos-nz_0lyd.asp

Also readup on...

Your going to have issues with this unless you want to keep the identity values consistent across both datases.

If you want to keep them consistent, then just set

Identity_Insert mytable...

Yeah, all the additional fields you want in our output will go into this part of the query. Just make sure if you add a field to the select,...

In this section of code right here, Add the columns you want in the procedure.

-- Berem obe stroki i logim ih v odnu select statement.

SET @SqlString = 'SELECT UserID, EventID,...