Make sure you have a working version of SQL Server 2016.
USE [master]
GO
/****** Object: Database [WorldHealth] ******/
CREATE DATABASE [WorldHealth]
CONTAINMENT = NONE
ON PRIMARY
(...
2016-08-16
393 reads
This TSQL tuesday is hosted by my good friend Jason Brimhall – Jason has put forth a creative challenge – plan to...
2016-08-10
290 reads
In the previous post I looked into some very basic and common measures of descriptive statistics – mean, median and mode,...
2016-07-24
603 reads
Make sure you have a working install of SQL Server 2016. The size of the database is only 8 MB.
USE...
2016-07-15
281 reads
I started my re-discovery of statistics with an introduction here. This second post is about descriptive statistics – very basic, simple...
2016-07-14
1,095 reads
I was a student of statistics in school and college. I didn’t get to use much of anything I learned...
2016-07-10
666 reads
This month’s TSQL Tuesday post is from one of my favorite people in the community – Jorge Segarra a.k.a. SQL Chicken. It...
2016-02-17
439 reads
For this post i worked on second puzzle in the Adventofcode series. This wasn’t as challenging as the first one, but...
2016-02-02
291 reads
I have been following the series of posts written by my friend and SQL MCM Wayne Sheffield on some TSQL...
2016-01-19
248 reads
Continuing with the recipes in SQL Server 2012 T-SQL recipes book – I was drawn to this puzzle that asked for...
2015-12-14
671 reads
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Hi everyone My SSIS package does a bulk insert of csv files into a...
Dipping my toes into the waters of Azure and of course before I get...
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers