Uncategorized
Drink more coffee, developers
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…
Read MoreSUBQUERIES: A lengthy primer
— 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…
Read More