Hey David,

i got the answer,its due to the space between the words in 1st column.Any idea how to consider those space as well

H David,

But that code is not working.i tried but it is not loading.its giving 0 rows processed but with no error

11.0
2

...

Hi ,
Thanks David  for the quick reply and it helped.But what if i have data with double qoute in the middle and will it start from "FIRST QOUTE"

Hi,

it is not giving any error but the data is not getting loaded.
0 rows processed.
Assuming i am doing some thing wrong with format files.

Thanks Luis for this.Is there any other way where i can do it without the help of WITH clause.i have some other more columns in select and i need to...

Hi,
Yes,we can't remove the duplicates and need to calculate the end date for each row and if the end date for the previous start date is same then we...

Thanks Luis for this.i have done this scenario with SQL and is working fine.But i have to implement it using procedure/function with LOOP .As may be tomorrow there will be...

Here is the Table1 Structure.

CREATE TABLE Table1(

Pegging varchar(20),

SKU VARCHAR(20),

QTY INT,

RDD DATE,

Component ...