View Complete Post
I got a scenario where we want to move some 30k records from a staging table to main table while moving we need to compare the columns from staging to history table and insert some new columns along with the columns in staging tables.
I will give one example.
Lets take staging table with scol1, scol2, scol3
Main table have mcol1, mcol2, mcol3, mcol4,mcol5,mcol6
History table have hcol1,hcol2, hcol3,hcol4, hcol5,hcol6
so i wil move the staging table to Main table by comparing columns scol1, scol2, scol3 with hcol1,hcol2, hcol3 and mcol4,mcol5,mcol6 will contain the 1 if values differ or 0 if it contains same value
I'm trying to passing field value adding double quote front and end for Go To report action.
If =fields!author_Name.value is TEST
I want to make it as "TEST"
Tried following expression
=""" & Fields!Author_Name.Value & """
Result is " & Fields!Author_Name.Value & "
I thought & will break "" but it is not.
We are using SQL Server 2005 x86 enterprise edition. We have one table which has 13 crores / 130 million records. When we insert a record in that table it is taking around 30 seconds. Can u please help optimize it.
The table currently has 1 primary key (Clustered Index) and 4 non clustered index.
When loading 50MB file with
BULK INSERT #FlatStage
WITH (ROWTERMINATOR = '\n')
I get the beginning of the file shifted to the middle approximately. Otherwise the lines are in order (so the document starts in the middle, progresses to bottom, continues at the top).