Is there any other approach other than this which we achieve the result as per requirement.:-)

We should not use a staging table while loading from source we should pull unique records in single table and the duplicate in next table without using row_number,rank & dense...

Last record means the final record which was inserted into the table the data has been inserted through the application

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

Create PROCEDURE [dbo].[USP_UpdateGroupAccess](@VALUE NVARCHAR(MAX),@STRING NVARCHAR(10))

AS

CREATE TABLE #GROUPACCESS(ID INT, DATA VARCHAR(100))

DECLARE @TEMP1 TABLE

(ID INT IDENTITY(1,1),

VALUE VARCHAR(MAX) )

INSERT INTO @TEMP1 SELECT * FROM DBO.SPLIT(@VALUE,@STRING)

--- DBO.SPLIT...

Hi , Thanks for your reply

i had tried this already if i pass the data in the paramater as ('1,4,2,2|2,4,3,5','|')

I am getting the result set as

ItemIndexItem

0 ...

hi,

I am not getting all databases names in the server from sys.dm_db_index_usage_stats because sql server was restarted last week.

hi ,

we are using sql server 2008 r2

how can i know if the sql server restarted then also how we can retrieve when database was last accessed .

Hi ,

Thanks for reply but in the link which was mentioned the script task has been used TO READ sheet name so without scipt task how to read a...

HI, by using the max function also we can populate the required data ......

With tenant_history(hmy, dtdate, htent, sevent, dtoccurred, dtmovein, dtmoveout )

AS

(

SELECT '176340','2011-08-26 00:00:00.000','55496','Notice Given ...

Hi from flat file fixed length data we can store into table using ssis but the length of source u given is 78 and in the data types which u...

hi,

i tried the same method but i am not getting the the record at all from that select becoz the catalog table has no record for the last executed...

Hi,

select MAX([TimeEnd]),Name

FROM [ReportServer].[dbo].[ExecutionLog] ,[ReportServer].[dbo].[Catalog]

where [ReportID]=[ItemID]

group by Name

will get enough information for me

but the concern is the latest report which i executed has...

Hi,

what is the use of the history table, in my db the history table is blank, it is not populated with data.

How to get the report_name and last_execution of...

The error which u mentioned above , in that parameter name is showing as unrecognized so may be the parameter which has chosen is not in that scope of package...