SSIS and its Uses

What is SSIS? SQL Server Integration Services(SSIS) is a platform that performs wide range of data integration and data transformation tasks. SSIS is a component of Microsoft SQL Server and is the evolution of a SQL Server module previously called Data Transformation Services (DTS). SSIS features a data warehousing tool that allows to develop data … Continue reading SSIS and its Uses

Sample Solution for Creating Stored Procedure using Search, Sort and Pagination with Parameters

CREATE PROCEDURE SP_OwnersListing ( @OwnersId int = NULL ,@SearchString nvarchar(max) = NULL ,@SortString nvarchar(max) = ' ' ,@PageNumber int = 1 ) AS BEGIN DECLARE @OLSortString nvarchar(max), @PageSize int SET @OLSortString = @SortString SET @PageSize = 10 SET @SearchString = LTRIM(RTRIM(@SearchString)) SELECT Owners.Id As OwnerID, RL.PropertyId, RL.Id As ListingId, Concat(A.Number,',',A.Street,',',A.Suburb,',',A.City)As Location, P.Bedroom, P.Bathroom, P.ParkingSpace, RL.Title, … Continue reading Sample Solution for Creating Stored Procedure using Search, Sort and Pagination with Parameters