Archive for August 2018

Coffee is a brewed beverage with a distinct aroma and flavor, prepared from the roasted seeds of the Coffea plant. The seeds are found in coffee cherries, which grow on trees cultivated in over 70 countries. Roasting coffee transforms the chemical and physical properties of green coffee beans into roasted coffee products. The roasting process…

— INPUT PARAMETERS DECLARE @FCT_DT DATE = ‘5/6/2016’ DECLARE @table VARCHAR(50) = ‘Person.Person’ DECLARE @strFactDate varchar(8) = convert(varchar, @FCT_DT ,112) DECLARE @newtable NVARCHAR(MAX) = @table + ‘_’ + @strFactDate DECLARE @sql NVARCHAR(MAX) DECLARE @cols NVARCHAR(MAX) = N” DECLARE @debug INT = 1 IF @debug = 0 BEGIN IF OBJECT_ID(@newtable) IS NOT NULL DROP TABLE Person.Person_20160506…