ConstantineK

SELECT *
FROM 
( 
	SELECT 
		STUFF(( 
		SELECT '' + comp.entity_data AS [text()]
		FROM (
			SELECT 
				DISTINCT 
				number		

ConstantineK

ConstantineK

CREATE OR ALTER procedure #data_sampler
(
	@schema_name NVARCHAR(128) = 'dbo',
	@object_name NVARCHAR(128)
)
AS 
BEGIN	
	SET NOCOUNT ON;

	DECLARE 

ConstantineK

declare @eva table -- entity value attribute 
(
	id int identity, -- we could use date here either
	type nvarchar(100),
	value nvarchar(100),
	student_identifier int
)

insert @eva (type, value, student_identifier) 
select 'studentid', '1', 3

ConstantineK

# write what we want, then use it in a loop 
function Update-Spaces {
  param ($path)
  $contents = Get-Content $path
  $contents -replace "\s+",", " | Set-Content $path -Force
}


# now say we have multiple files, we need to loop and rewrite
# for each file in the folder that the script provides, filtering files that contain the filter

ConstantineK

AdventureWorksDW2016

Tables

Click to expand

• dbo.AdventureWorksDWBuildVersion
• dbo.DatabaseLog
• dbo.DimAccount
• dbo.DimCurrency

ConstantineK

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\SOFTWARE\Microsoft\Windows\CurrentVersion\Feeds]
"EdgeMUID"="3F61B1E2FEFB605D2878BB1DFFEC6166"
"IsAnaheimEdgeInstalled"=dword:00000001
"osLocale"="en-US"
"IsFeedsAvailable"=dword:00000000
"ShellFeedsTaskbarViewMode"=dword:00000002
"HeadlinesOnboardingComplete"=dword:00000001