From whatever I could understand I came up with this script. Try this and tell me if it meets your requirement.

--Create Table

Create Table Ex

(Itemcode varchar(10),

Field1 varchar(10),

Field2 varchar(10),

Field3...

If you mean that A100 and C100 are same on the basis of field values, then instead of using cursor then can be selected in a SET based manner as...

"Example

Itemcode Field 1 Field 2 Field 3 Field 4

A100 A B C D

B100 B C D E

C100 A B C D

The unique items are thus A100 & C100. We...

Here is my point of view on when to use which Replication Topology:

Snapshot Replication

Use snapshot replication when you want an occasional data push done. Because all data is moved...

What do you mean by BLOCKING?

According to Microsoft the following is BLOCKING:

Blocking

Is that what you mean??...

Anyways you can get the Database back to that state if you have a Database...

If the id in first table is an Identity, then you have to use Scope_Identity to know the last inserted Identity and then insert value into the other table with...

I am not sure about this(haven't faced such a problem before), but maybe the SSIS installed is the 32 bit version and may not work for 64 bit.

Have you checked...

Q. Can you use a table to join multiple columns?

Yes, Using Aliases.

;WITH fechas (fecha) AS (

SELECT GETDATE() AS fecha UNION ALL

SELECT DATEADD(day,10, fecha) from fechas )

select fecha from fechas

option (maxrecursion 32767)

The above code causes an infinite recursion. "SELECT DATEADD(day,10, fecha)...

Yea. Select works multiple times in an SP.

The difference between using PRINT and SELECT is simply the difference of a SQL DBA's(or developers) thinking and any other developer's thinking.

SQL was...

Did you install Integration Services independantly??...

You're Welcome. I'm glad I could help.

If you can see the job using Windows Explorer then do the following to create a job and run it as a part of the trigger. I just tried this...

+1 on dat Jeff.

My Sincere thanks to everyone.

Unique Index - Allows one(and only one) Null value.

Primary Key - Does not allow Nulls.