How do you get EPPlus.dll installed in GAC on windows server 2008 R2 without GACUTIL or Win SDK?

Thanks!!

I am trying to understand why SQL Server is updating records using two different rows? My thinking was in any case it gets all columns updated from one row.

you can check this more real example too.

create table #Data

(

COMPANY int,

NAMEvarchar(50),

SALARY int

)

create table #Random

(

Random_COMPANY int,

Random_NAMEvarchar(50),

Random_SALARY int

)

insert into #Data (COMPANY, NAME) values (1, 'ABC' )

insert into #Data...

Source Table1

idval1val2

11NULL

123

Destination Table before update

idval3val4

188

Expected Destination Table after update - Option 1

idval3val4

11NULL

Expected Destination Table after update - Option 2

idval3val4

123

Destination Table after update - Real Output

idval3val4

113<-- This should be null

BOB: Are you saying that you can at this moment change from nvarchar back to varchar and see the performance degrade, even if you run the stored procedure with the...

I have checked execution plan. It is same for NVARCHAR and VARCHAR.

I tried on three different servers. and on all three servers I am getting same perfromance.

I am also surprised...

Very Nice Article.

I have one doubt about table variable.

Inside one of my SP, I am storing values in table variable to loop through the records.

If number of records inserted in...

Thanks for the reply. I was confused by reading so many forums for cursor, which has many different explanation for cursor. I got the answer why cursor is slow. It...

@Gila Monster:

You said that cursor is working iteratively, My Question is that table variable is also works on iteration. so why only cursor is slow? and not table variable.