gartha1

' this one is like Get Data 1.txt but I am using the reference Book.dbo.BooksDetail 
' and I have puts the DROPS at the beginning too as that helps it to work 

DROP TABLE #tempH
DROP TABLE #tempMorph
DROP TABLE #tempV
DROP TABLE #temp
DROP TABLE #tempfinal

----------get data from raw material-------------------

gartha1

Jan 26 01:30:16 ruby-railsx01 sshd[3715]: Accepted password for root from 82.x.x.2   port 51908 ssh2
Jan 26 01:33:50 ruby-railsx01 sshd[3715]: Received disconnect from 82.x.x.248 port 51908:11: disconnected by user
Jan 26 01:33:50 ruby-railsx01 sshd[3715]: Disconnected from 82.x.x.248 port 51908
Jan 26 01:34:06 ruby-railsx01 sshd[3885]: Accepted password for root from 82.x.x.2   port 51935 ssh2
Jan 26 01:35:16 ruby-railsx01 sshd[3885]: Received disconnect from 82.x.x.248 port 51935:11: disconnected by user
Jan 26 01:35:16 ruby-railsx01 sshd[3885]: Disconnected from 82.x.x.248 port 51935
Jan 26 01:35:34 ruby-railsx01 sshd[4032]: Connection closed by 82.x.x.248 port 51966 [preauth]
Jan 26 01:35:37 ruby-railsx01 sshd[4034]: Connection closed by 82.x.x.248 port 51970 [preauth]
Jan 26 01:35:42 ruby-railsx01 sshd[4036]: Accepted password for root from 82.x.x.2   port 51971 ssh2
root@ruby-railsx01:~#

gartha1

var lastScrollHeight = 0;
function autoScroll() {
  var sh = document.documentElement.scrollHeight;
  if (sh != lastScrollHeight) {
    lastScrollHeight = sh;
    document.documentElement.scrollTop = sh;
  }
}
window.setInterval(autoScroll, 100);

gartha1

I have noticed that academics tend to say it’s with w(though that may change!), and most jews pronounce it v, though some jews e.g. those taking a traditional iraqi pronunciation pronounce it w, as do yemenites.

It may be that an argument can be made that the original pronunciation was vav.

In fact, according to Nehemia Gordon, according to an expert professor from the Academy Of The Hebrew Language, that he spoke to, it is certainly V not W.


The Pronunciation of the Hebrew Letter Vav (Nehemiah Gordon)
https://www.youtube.com/watch?v=0td4d2UGP0k

gartha1

USE [Book]
GO
/****** Object:  StoredProcedure [dbo].[showdata]    Script Date: 19/03/2018 10:43:44 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>

gartha1

-- https://stackoverflow.com/questions/1324869/easiest-way-to-import-csv-into-sql-server-2005
-- https://stackoverflow.com/questions/5498033/how-to-write-utf-8-characters-using-bulk-insert-in-sql-server

drop table Bib.dbo.bbb


CREATE TABLE Bib.dbo.bbb
(RowNum INT,
BookNum INT,

gartha1

USE [Book]
GO
/****** Object:  StoredProcedure [dbo].[showdata]    Script Date: 29/03/2018 1:32:19 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>

gartha1

USE [Book]
GO
/****** Object:  UserDefinedFunction [dbo].[ufnGetDetils]    Script Date: 29/03/2018 1:43:52 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER FUNCTION [dbo].[ufnGetDetils](@V NVARCHAR(100),@Morph NVARCHAR(100),@H NVARCHAR(100))  
RETURNS NVARCHAR(2000)   
AS   

gartha1

SELECT (SELECT #tempH.[Root] FROM #tempH WHERE bd.H=#tempH.[Root]) AS [Root] ,
(SELECT #tempV.Morph FROM #tempV WHERE bd.V=#tempV.Morph) AS Morph ,
(SELECT #tempMorph.H FROM #tempMorph WHERE bd.Morph=#tempMorph.H) AS H

FROM dbo.BooksDetail bd GROUP BY bd.H,bd.V,bd.Morph

gartha1

-- KEEPING THIS THE SAME. IT HAS MUCH SIMPLER SQL


USE [Book]
GO
/****** Object:  StoredProcedure [dbo].[showdata2]    Script Date: 1/04/2018 2:09:03 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO