Database

Command Insert
SET QUOTED_IDENTIFIER OFF 
SET ANSI_NULLS ON
INSERT INTO [jbmolver].[dbo].[all_tweets] ([set_str],[name]) VALUES 
("INSERT INTO [jbmolver].[dbo].[Twitter_Feeds] ([Twitter_ID],[Feed_ID],[Twitter_Date],[screen_name],[Author_Details],[Author_Email],[Author],[Sentiment],[sdate],[edate],[keyword],[type],[ncount],[latitude],[longitude],[radius],[lang],[friends_count],[followers_count],[following],[statuses_count],[location],[time_zone],[description],[in_reply_to_status_id],[in_reply_to_user_id],[in_reply_to_screen_name],[Rcounter],[address],[Feed_From_SM],[profile_image],[current_user_retweet],[withheld_scope],[retweet_count],[favourites_count],[url_type],[hashtags],[expanded_url]) VALUES ('933231091967778816','799796908478894080','2017-11-22 09:10:05',N'prettyraebae',N'Sis it s almost 2018 😭 https://twitter.com/babydrii_/status/933230970412683264', '', 'Rae', '1', '', '', '', 'photo', '', '', '', '', 'en', '461', '737', '', '12503', '', '', N'UGA 20 ❤️', '', '', '', '0', '$', '2', 'http://pbs.twimg.com/profile_images/867998936388313089/2Zdl5P2-_normal.jpg', '0', '0', '0', '27988', '', '', '')", 'Twitter_Feeds')

Table No. One:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[all_tweets](
[id] [int] IDENTITY(1,1) NOT NULL,
[set_str] [nvarchar](max) NULL,
[name] [nchar](30) NULL,
CONSTRAINT [PK_all_tweets] PRIMARY KEY CLUSTERED 
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

Trigger on Table One:

/****** Object: Trigger [dbo].[exec_Update] Script Date: 11/23/2017 5:09:00 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[exec_Update] on [dbo].[all_tweets]
AFTER INSERT
AS 
BEGIN
declare @id int = 0
set @id = ( select top 1 id from inserted )
exec [dbo].[execute_all_tweets] '[dbo].[all_tweets]','[set_str]',@id
END

Table Number Two
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Twitter_Feeds](
[id] [int] IDENTITY(1,1) NOT NULL,
[Twitter_ID] [bigint] NOT NULL CONSTRAINT [DF_Twitter_Feeds_Twitter_ID] DEFAULT ((0)),
[Feed_ID] [nvarchar](50) NULL,
[Twitter_Feed] [varchar](200) NULL CONSTRAINT [DF__Twitter_F__Twitt__6E01572D] DEFAULT (''),
[Resource] [nchar](50) NULL CONSTRAINT [DF_Twitter_Feeds_Resource] DEFAULT (''),
[Twitter_Date] [datetime] NULL,
[screen_name] [nvarchar](50) NULL CONSTRAINT [DF__Twitter_F__scree__6FE99F9F] DEFAULT (''),
[friends_count] [nvarchar](50) NULL CONSTRAINT [DF__Twitter_F__frien__70DDC3D8] DEFAULT (''),
[followers_count] [nvarchar](50) NULL CONSTRAINT [DF__Twitter_F__follo__71D1E811] DEFAULT (''),
[following] [nvarchar](50) NULL,
[statuses_count] [nvarchar](50) NULL,
[description] [nvarchar](max) NULL CONSTRAINT [DF__Twitter_F__descr__72C60C4A] DEFAULT (' '),
[Author_Details] [nvarchar](max) NULL CONSTRAINT [DF_Twitter_Feeds_Author_Details] DEFAULT (''),
[Author_Email] [varchar](100) NULL CONSTRAINT [DF__Twitter_F__Autho__74AE54BC] DEFAULT (''),
[Author] [nvarchar](100) NULL CONSTRAINT [DF__Twitter_F__Autho__75A278F5] DEFAULT (''),
[Sentiment] [int] NULL CONSTRAINT [DF__Twitter_F__Senti__76969D2E] DEFAULT ((0)),
[sdate] [date] NULL,
[edate] [date] NULL,
[keyword] [nvarchar](250) NULL CONSTRAINT [DF__Twitter_F__keywo__778AC167] DEFAULT (' '),
[type] [nvarchar](50) NULL CONSTRAINT [DF_Twitter_Feeds_type] DEFAULT (' '),
[ncount] [int] NULL,
[latitude] [nvarchar](50) NULL CONSTRAINT [DF__Twitter_F__latit__787EE5A0] DEFAULT (''),
[longitude] [nvarchar](50) NULL CONSTRAINT [DF__Twitter_F__longi__797309D9] DEFAULT (''),
[radius] [nvarchar](50) NULL CONSTRAINT [DF_Twitter_Feeds_radius] DEFAULT ((0)),
[lang] [nvarchar](5) NULL,
[in_reply_to_status_id] [nvarchar](50) NOT NULL CONSTRAINT [DF_Twitter_Feeds_in_reply_to_status_id] DEFAULT ((0)),
[in_reply_to_user_id] [nvarchar](50) NOT NULL CONSTRAINT [DF_Twitter_Feeds_in_reply_to_user_id] DEFAULT ((0)),
[in_reply_to_screen_name] [nvarchar](50) NULL,
[Rcounter] [int] NULL CONSTRAINT [DF_Twitter_Feeds_Rcounter] DEFAULT ((0)),
[country] [nvarchar](100) NULL,
[State] [nvarchar](50) NULL,
[City] [nvarchar](50) NULL,
[address] [varchar](250) NOT NULL CONSTRAINT [DF_Twitter_Feeds_address_1] DEFAULT (''),
[location] [nvarchar](50) NULL,
[time_zone] [nvarchar](50) NULL CONSTRAINT [DF_Twitter_Feeds_time_zone] DEFAULT (' '),
[Feed_From_SM] [int] NOT NULL CONSTRAINT [DF_Twitter_Feeds_Feed_From_SM] DEFAULT ((1)),
[gender] [int] NOT NULL CONSTRAINT [DF_Twitter_Feeds_gender] DEFAULT ((0)),
[Client_id] [int] NOT NULL CONSTRAINT [DF_Twitter_Feeds_Client_id] DEFAULT ((0)),
[image] [image] NULL,
[profile_image] [nvarchar](180) NULL,
[withheld_in_countries] [nchar](50) NULL CONSTRAINT [DF_Twitter_Feeds_withheld_in_countries] DEFAULT (''),
[withheld_scope] [nchar](10) NULL CONSTRAINT [DF_Twitter_Feeds_withheld_scope] DEFAULT (''),
[retweet_count] [int] NULL CONSTRAINT [DF_Twitter_Feeds_retweet_count] DEFAULT ((0)),
[current_user_retweet] [int] NULL,
[favourites_count] [int] NULL,
[expanded_url] [nvarchar](max) NULL,
[url_type] [nchar](150) NULL,
[hashtags] [nchar](150) NULL,
CONSTRAINT [PK_Twitter_Feeds_2] PRIMARY KEY CLUSTERED 
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

Trigger On table number two
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[wordlist_splite_update] on [dbo].[Twitter_Feeds]
AFTER INSERT
AS 
BEGIN
--set nocount on
DECLARE @MyString NVARCHAR(100),@TABLENAME NVARCHAR(50)='[dbo].[twitter_feeds]',@FIELD NVARCHAR(50)='[author_details]',@min int = 4
SET @MyString = ','
declare @Country nvarchar(80),@State nvarchar(50),@City nvarchar(50),@y int, @i int
declare @w1 Nvarchar(256),@w2 Nvarchar(256),@w3 Nvarchar(256),@w4 Nvarchar(256),@fld Nvarchar(256),@ID INT,@Twitter_Date datetime

set @fld = (select top 1 keyword from inserted)
set @Twitter_Date = (select top 1 Twitter_Date from inserted)
set @id = (select top 1 id from inserted)
SET TEXTSIZE 2147483647;
--exec [dbo].[top_word_list_by_location] '[twitter_feeds]','[author_details]', @id 

IF OBJECT_ID('dbo.Cur1', 'U') IS NOT NULL 
DROP TABLE dbo.Cur1;
IF OBJECT_ID('dbo.sometable', 'U') IS NOT NULL 
DROP TABLE dbo.sometable; 

--SET NOCOUNT ON
DECLARE @Words INT, @Pos INT, @x Int, @str varchar(256),@screen_name nvarchar(100),@Author_Details nvarchar(280)
, @word varchar(256), @start int, @end int, @exitstart int
SELECT @Words = 0, @Pos = 1, @x = -1, @Word = '', @start = 1

if @id > 0
begin
exec('DECLARE Cur1 CURSOR FOR SELECT id, [screen_name],('+@FIELD+'),Twitter_Date FROM '+@TABLENAME +'where id='+@id )
end
else
begin
exec('DECLARE Cur1 CURSOR FOR SELECT id, [screen_name],('+@FIELD+'),Twitter_Date FROM '+@TABLENAME)
end


OPEN Cur1

fetch next from cur1 into @id,@screen_name,@str,@twitter_date
--insert into [dbo].[wordlist] ([word]) values (@id)

while @@fetch_status = 0
begin
select * into #temp from [dbo].[splitwords](@str)
set @y = (select count(*) from #temp)
set @i = 1

while @i <= @y
begin
--insert into [dbo].[wordlist] ([word]) values (@i)
set @word = (select [value] from #temp where id = @i)
set @word = (select [dbo].[udf_parsealphachars](@word))
if not exists (select * from dbo.dictionary with(nolock) where word= ltrim(rtrim(@word)))
begin
if not exists(select * from [dbo].[wordlist] with(nolock) where (word=ltrim(rtrim(@word)) and used_day = day(@twitter_date) and used_month = month(@twitter_date) and used_year = year(@twitter_date)) and (ltrim(rtrim([screen_name])) = ltrim(rtrim(@screen_name)) and nullif(word,' ') is not null))
begin
if len(ltrim(rtrim(isnull(@word,'')))) >=0 -- @min
begin

insert into [dbo].[wordlist] ([word],[used_day],[used_month],[used_year],[screen_name],[add_dt])
(select ltrim(rtrim(@word)),day(@twitter_date),month(@twitter_date),year(@twitter_date),@screen_name,@twitter_date where (len(isnull(@word,'')) > @min))

end ---- if len(ltrim(rtrim(isnull(@word,''))))

end --- if not exists [dbo].[wordlist]
else
begin
update wordlist set wordcount = wordcount + 1,[lastupdate] = getdate() where word = ltrim(rtrim(@word)) and (len(isnull(ltrim(rtrim(@word)),'')) > @min) and (ltrim(rtrim(@word)) <> '-1')
end --- else [dbo].[wordlist]
end --- if not exists [dbo].[wordlist]

set @i = @i + 1
end ---- end while dbo.dictionary

fetch next from cur1 into @id,@screen_name,@str,@twitter_date
end ---- end fetch next 


close cur1
deallocate cur1
--set nocount off

--exec('select top '+ @top +' * from wordlist order by wordid desc')

if object_id('dbo.cur1', 'u') is not null 
drop table dbo.cur1;
if object_id('dbo.#temp', 'u') is not null 
drop table dbo.#temp; 
--set nocount off
end 

I want to change the old store to new store by using the query in MSSQL. For example,

Staff_Id Name Transaction_Date New_Store Old_Store 
--------------------------------------------------
1        AA   1.1.2017         1

1        AA   1.2.2017         2

1        AA   1.3.2017         3

1        AA   1.4.2017         1

1        AA   1.5.2017         4

I want to change the table to following like that 
Staff_Id Name Transaction_Date New_Store Old_Store
--------------------------------------------------
1        AA   1.1.2017         1         NULL

1        AA   1.2.2017         2         1

1        AA   1.3.2017         3         2

1        AA   1.4.2017         1         3

I wrote the query like that, but it's not true, it's output randomly

Update EC1 SET EC1.Old_Store=EC.New_Store
 From Employee_Change EC , Employee_Change EC1 
WHERE EC.Staff_Id=EC1.Staff_Id 
AND EC.Transaction_Date>=EC1.Transaction_Date

1. is it because of the multiple sheets or
2. is it because of the Jet drivers,
3. The file path is too long (I saw its 150 characters as it shows, the variable datatype that holds the File name is String)
4. or if the File full Path combined with connection string value, does it become too long to be hold by the Connection string of the Source Connection?