Putting Corrections in Perspective using Power BI
My enthusiasm for analyzing stock market data using Power BI – even after publishing two posts recently (this and this) – is at...
2015-10-13
587 reads
My enthusiasm for analyzing stock market data using Power BI – even after publishing two posts recently (this and this) – is at...
2015-10-13
587 reads
What’s my share? Calculating percent share of the total is a common need. Let’s see how to calculate this in Power BI...
2015-10-06 (first published: 2015-09-29)
24,986 reads
My article “SSIS Design Pattern – Staging Fixed Width Flat Files” is published on SQLServerCentral.com. In the article, I provide a...
2015-10-06
692 reads
There’s a saying that birds of the same feather flock together. When you throw your data on a scatter chart,...
2015-09-25 (first published: 2015-09-14)
3,134 reads
Let’s say you have a table that records transactions along with the date of when the transaction took place. Wait,...
2015-09-22
5,242 reads
When you start working in ETL (Extract, Transform, and Load) or SSIS projects, you’ll be faced with two basic terms:...
2015-09-16 (first published: 2015-09-08)
34,162 reads
U.S. stock markets have taken a beating this past week fueled by China markets. Take a look at how China and...
2015-09-02 (first published: 2015-08-24)
3,564 reads
About 80% of the world’s population lives in about 13% of the countries. Okay, this statement is not as knee-jerking...
2015-09-01
7,196 reads
S&P 500 index is an American stock market index consisting of 500 large companies and is considered to be the...
2015-08-17
2,719 reads
Blank values are annoying, anywhere and everywhere. If your source system contains them, here’s how to convert blank values to NULL in...
2015-08-11
15,717 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Pay for Performance, which is...
WhatsApp:0817819444 Jl. Pemuda No.3 C, Tawangsari, Leteh, Kec. Rembang, Kabupaten Rembang, Jawa Tengah 59217
WhatsApp:0817819444 Jl. Pemuda No.57B, Blora, Tempelan, Kec. Blora, Kabupaten Blora, Jawa Tengah 58211
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, 'true')
GO
See possible answers