Check this Link

My question would be, why you want this behavior especially on the primary key which is having an Identity? Why you want to avoid gaps in a identity???

How about this :

/* ACTUAL TABLE */

DECLARE @Actual TABLE (ReportDate date , DatabaseName varchar(10), ReportID int , TotalSum bigint )

INSERT INTO @Actual

SELECT '2016-06-26', 'Test1' , 1, 150

UNION ALL

SELECT '2016-06-27',...

Please check this link

sample data and desired output will be a lot helpful.

Its always better to share the query in text instead of a image it make things a lot easier for the folks.

Following will achieve the result:

SELECT

Zone, ItemCode, [Products], GrossWt

FROM

(

SELECT...

Well there can be many scenarios for example one possible case can be that you are running your package on the Db machine, and there is not enough memory for...

It would be wise to wait for your answer on your original thread. Instead of opening a new thread. Where u haven't mentioned any details.

Please refer to the following link...

Declare @Actual Table

(

ItemState varchar(10)

, Car varchar(10)

, Truck int

, Boats int

, Planes int

)

insert into @Actual

select 'old', 'volvo', 89, 65, 67 union all

select 'new', 'pinto', 102, 55, 12...

Well, the Clue is in you Sample data generation query. if you build your query according to that logic you will be able to get your desired output.

something like this:

WITH...

please read all the comments above your reply and also read this Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

and then reply....

This will not work as in when UNION is...

I have updated your query to avoid into error you are getting. following is the code

DECLARE @TBLNAME varchar(8000) = 'Employee'

DECLARE@SchemaName varchar(200) = 'dbo'

DECLARE @InsertColumnList nvarchar(max)

DECLARE @SelColumnList nvarchar(max)

DECLARE @INSERTSQLSTRING nvarchar(max)

DECLARE...

Well, you have already restricted SQL SERVER on 10 gb. which means u have 6 gb for OS and other thing.

Upon checking, I found that Maximum server memory set in...

Handy thing only if you remember it at that time 😛

Nice question Ben and thanks for sharing.