It depends you need it critically or not?

@Cgyrob NOO it's part from SQL Server

What's the edition you are using + did you install server tools or client tools?

Are you using SQL Server? You can post your question to PHP forum as I don't know where your problem exists?!

Update statement:
You should send the ID and the Value be deduction from the existing quantity

Update Table
Set Quantity = Quantity - @Value
Where ID=@ID

hmmm, where is the question? I don't know in what you have problem.

Please mention your version of SQL Server to get the best tutorial for you I assume you are using 2005 here you are:...

Can you please try that on SSMS, and see what happens? it may there something wrong from C#.

It's independent ETL solution by Microsoft but from any source to any destination and you don't need to have SQL Server as software or staging to move data, I highly recommend you to use it, any help...

what about SSIS? I didn't use SSMA.
You can use SSIS to move\copy data in fast and smooth way.

Your thread subject is totally different than the thread itself.
Sknake, they can't use SQL Profiler as
Log file is your eye, you can see through each transaction happened.

As you like you can do it in BLL (Business logic layer) or you can do it as constrains in database.
About generating strings you can see that http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=59194

Triggers, and Events not called by you, rather called on something happens. As Sknake recommended ask more about SQL Triggers in MS SQL forum http://www.daniweb.com/forums/forum127.html

There's no triggers in C# rather events.

Greate, Sknake

Open new query document and copy the script and paste it there.

You don't avoid injection just from application, but to run any code against the SP + it's not maintainable and this is the big risk in business application development, I'm sure for every scenario...

Yes you need some tutorial in T-SQL as said, please contact me to provide you with some books.

You can discuss that in MySQL forum http://www.daniweb.com/forums/forum126.html please help moderators to keep the Daniweb organized.

Dynamic SQL is very risky!!

I recommend you to normalize your table first then we can engage with SQL.

Should I ask you the same questions?
OK, Please tell me what you are going to do?

Check this http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/867b3a86-18ad-45f8-b051-4e7312233587/ or search on that...

As SQL shows date fields in correct format (like you want) so the problem in your third party that maps data types between SQL Server and MySQL. Check if you can configure mapping processing to...

What's the tool you use to migrate?

Do you have any triggers on those tables?

First your question should be in C# Forum http://www.daniweb.com/forums/forum61.html
Second, it should raise exception but you don't show it "blank catch block" modify it to

catch (Exception ex)...

blabla blabla blabla I don't understand anything.
Logically you need to update the two columns of table2 when the primary key of table1 changes?

You can use triggers as said in the KB.

It's remote server?

Tell me the error please, or send me the access file, to try.
<EMAIL SNIPPED>

SELECT Subjects.Subject_ID, Subjects.SubjectCode, Subjects.SubjectName, Visits.Date, Visits.Comment
FROM Subjects INNER JOIN Visits ON Subjects.Subject_ID = Visits.Subject_ID
Where...

Here you're

SELECT WorkOrders.ID, employees.name, employees_1.name AS Expr1
FROM WorkOrders LEFT OUTER JOIN
employees AS employees_1 ON WorkOrders.submitted_by...

Give us more explanation.
What the table you need to update its values by which table?

Copy your query here which raises this error.

Remove alias and use the table name directly. Replace every T1 & T2 with tblEmailClub

After digging I came with bad performance solution :s but I think it works,

SELECT
T1.address1,
tblEmailClub.emailclub_id,
tblEmailClub.firstname,
tblEmailClub.lastname,
tblEmailClub.email,...

You've right, I'll try something else and reply you.

No, distinct works on column and it removes the duplication, I tried it myself.

hmmm, That's because of obligation of being distinct in first place

SELECT
DISTINCT (tblEmailClub.address1),
tblEmailClub.emailclub_id,
tblEmailClub.firstname,
tblEmailClub.lastname,...