SQL Kiwi (1/26/2012)

---

This demonstrates one technique:

CREATE TABLE #Example

(

BrandId integer NOT NULL,

ProductId integer NOT NULL,

...

I would appreciate if someone could help me out here or else let me know if none of you dont understand or dont know what I am talking about.

yes format of each file is similar, now a I am able to configure xml task but I am stuck at configuring xml source how I am going to pass...

ok, let me explain from the scratch what I am trying to do is I have multiple XML files, I need to bulk insert each one into a table in...

Lowell (4/18/2011)

---

what is the name of the identity column in the table [stocktb]?

are you trying to force stocktb.[identitycolumn?] to be exactly the same as the productid from the other table,...

no I am not doing any replication here, I am trying to just insert the data from one table to another and the identity...

Lowell (4/18/2011)

---

what is the name of the identity column in the table [stocktb]?

are you trying to force stocktb.[identitycolumn?] to be exactly the same as the productid from the other table,...

ColdCoffee (3/31/2011)

---

Try this:

declare @WSUrid numeric

declare @WSUrnam varchar (100)

declare @WSPrice1 varchar (100)

declare @WSPrice2 numeric

declare @WholesalePrice...

toddasd (3/31/2011)

---

declare @WSUrid numeric

Why is this ID field a numeric? You have decimal IDs?

set @WSPrice1 = 'Select ISNULL(' + @WSUrnam + ',0) from dbo.productstb where productid =...

WayneS (3/31/2011)

---

ptlbiren (3/31/2011)

---

I AM GETTING FOLLOWING BELOW ERROR

Msg 8115, Level 16, State 6, Line 14

Arithmetic overflow error converting varchar to data type numeric.

And also correction in above update statement it...

I AM GETTING FOLLOWING BELOW ERROR

Msg 8115, Level 16, State 6, Line 14

Arithmetic overflow error converting varchar to data type numeric.

And also correction in above update statement it is

Update...

because in .csv file the columns containing values such as '0008' takes as '8' so i want to avoid using .csv format.