SQL-Server-R-Services-Samples/SQLOptimizationTips/SQLR/step2_load_data.sql at master · TheRockStarDBA/SQL-Server-R-Services-Samples · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
USE ResumeMatching
GO

INSERT INTO [dbo].[Projects]
EXEC sp_execute_external_script
@language = N'R',
@script = N'OutputDataSet <- read.csv(file=file.path("C:\\resumematching\\Data\\", "Job_Features.csv"), h=T, sep=",")'


INSERT INTO [dbo].[Resumes]
EXEC sp_execute_external_script
@language = N'R',
@script = N'OutputDataSet <- read.csv(file=file.path("C:\\resumematching\\Data\\", "Resume_Features.csv"), h=T, sep=",")'


INSERT INTO [dbo].[LabeledData]
EXEC sp_execute_external_script
@language = N'R',
@script = N'OutputDataSet <- read.csv(file=file.path("C:\\resumematching\\Data\\", "Labled_Data.csv"), h=T, sep=",")'