Hello Steve,

Apologies for being late in reply, we had a discussion with client and they don't want to increase the RAM size ,

Hence i have changed the script , used...

Hi Jeffrey,

we are working in insurance domain and we need to save data in xml file in ftp server , it is a business requirement.

and Yes 1Lakh records = 100000...

Hi Steve,

all columns have varchar(100) datatype , we are not using any varchar(max) column or nvarchar(max) columns.

"very slow" query is running for more than 2 hours and then package gets...

Thank You Steve,

Source table       : No of records : 20 lakh and may increase, no of columns are 55 and it may also increase.

Requirement is : We need...

Thank You @Erland,

We have a table "employee_table" in which i want to add a column known as  "HashValue" and "HashValue" column will be populated using HashByte function.

but we want to...

Thank You Everyone,

Can we have add Hash-byte on column for only insert operation but on update operation.

Could you please suggest.

• This reply was modified 5 years, 4 months ago by  Abhi kr.
• This reply was modified 5 years, 3 months ago by  Abhi kr.

data will be of type documents  - pdf , doc etc

Apologies for being late ,

my requirement is i am taking min of snapshot date from one of my table .

for ex :

select Min (Snapshot_date) from table.

Suppose output will be...

Hi Eric M Russell,

I think you are right and i feel i got the answer ,

Let me incorporate the changes Thanks a lot buddy,

Next I will be posting issue...

Strange thing is there is no such issue ..

no jobs are running which are deleting data

I Feel there is no problem with the code . below Approach i am using for other tables but

everything looks fine there .

Issue is only with one tables ....

Hi Everyone ,

Thanks for your quick response .

Here is the problem .

1) Using merge script while inserting data into the table (Sql server 2012).

2) After inserting a particular set of...