I have a staging table which has unprocessed records of the batch..<br><br>I need a query or stored procedure which should validate the unprocess records and log the records into another table which is not valid records and also need to log the passed ...

We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...

Please help to correct the query.. CREATE TABLE dbo.MyTable ( MasterIp varchar(255) NOT NULL CONSTRAINT PK_MyTable PRIMARY KEY ,status1 tinyint NOT NULL ,status2 tinyint NOT NULL ,Active_status tinyint NOT NULL ) GO...

T1.MasterIp ORDER BY T1.MasterIp DESC ) P; -- Rows with Children UPDATE C SET status2 = I.status2 ,Active_status = I.Active_status FROM inserted I JOIN MyTable C ON C.Maste...

Thanks for the reply Mitesh May be i was not clear in explaining my question. I need a query which should gives the list of objects (tables,views,sp,etc) being used in SSIS packages for evaluation ....

I need a script to identify the cross references of objects like storedprocedures,views,tables,function etc. from SSIS packages....

I need a script to identify the cross references of objects like storedprocedures,views,tables,function etc. from SSIS packages. ...

I would like to export a MS Excel file generated By SSRS 2008 and dynamically change the sheet name (Sheet 1,Sheet 2,Sheet 3). How could i achieve the above output.. Please provide me step by step details and i very new to SSRS.. Note:I have sqlserv...

I would like to export a MS Excel file generated By SSRS 2008 and dynamically change the sheet name (Sheet 1,Sheet 2,Sheet 3). How could i achieve the above output.. Please provide me step by step details and i very new to SSRS.. Note:I have sqlserver...