Database

SET @sql =N'INSERT INTO TrackUpdatedColumnNamesFlatTable (TableName, ColumnName, PrimaryKeyColumnName, PrimaryKeyValue, TransactionId
    , TransactionType, CreatedBy, ModifiedBy, CreatedDate, ModifiedDate, IsSoftDelete, IsCmsActive, ColumnValueAfter)
    select ''' + @TblName + ''', ''' +  @ColName + ''', ''' +  @PKColName + '''
    , ' +  @PKColName + ', $start_lsn , CASE WHEN ($operation=1) THEN ''Delete''
    WHEN $operation=2 THEN ''Insert''
    WHEN __$operation=4 THEN ''Update''
    END TransactionType, CreatedBy, ModifiedBy, CreatedDate, ModifiedDate
    , ' + CAST(@IsDeleted AS varchar(max)) + '
    , ' + CAST(@IsCmsActive AS varchar(max)) + '
    , CASE WHEN __$operation=1 THEN NULL ELSE CAST(' + @ColName + ' AS nvarchar(max)) END<br />
FROM [cdc].' + @cdcinstancename
+ ' WHERE CAST(sys.fn_cdc_map_lsn_to_time($start_lsn) AS DATE)=CAST(''' + @DateToTrack + ''' AS DATE)
AND sys.fn_cdc_is_bit_set(sys.fn_cdc_get_column_ordinal(''' + @captureinstance +
''',''' + '' + @ColName + '''), __$update_mask) = 1
AND __$operation IN (1, 2, 4)';

exec sp_executesql @sql, N'@IsColumnModified int out', @IsColumnModified out

Hello All,

I would like to convert reports in the format .rdlc into format .rdl using Visual Studio 2015.

What I did: I've created a Reporting project(existent under Visual C# templates) where I added two reports. Those reports come with the extension .rdlc. After creating the project I checked its properties and the type of project is windows application. Further I decided to use SQl Server Reporting Services to do my reports. I installed Data Tool preview for Visual Studio 2015 and created a Reporting Services project under Business Intelligence template.

Issue:
The reports I initially created using the Reporting project have the extension .rdlc and the ones created with Reporting Services .rdl. I imported the .rdlc ones into my Reporting Services project. However if I change the extension from .rdlc to .rdl i can design but not preview. When trying to preview, Visual Studios says "an error occurred during local report processing. error in the application. Object reference not set to an instance of an object".
I would not want to loose those two reports as the design took me one day to do.If anyone knows a solution that I could use to import/convert .rdlc reports into .rdl I would appreciate.

Column names in each table must be unique. Column name 'ApplicationId' in table 'TempDelta' is specified more than once.

select * into TempDelta from [Application] a
inner join ApplicationComponent b on a.ApplicationId=b.ApplicationId
inner join ApplicationPage c on a.ApplicationId=c.ApplicationId
inner join Audit  d on a.ApplicationId=d.ApplicationId
inner join OrgEntityApplication  e on a.ApplicationId=e.ApplicationId