Love the topic. Calendar tables are quite useful, and are being considered more and more for use cases beyond the data warehouse.

speedcat (9/7/2016)

---

We have the same cost concerns. Our system may not have the processing or access concerns that some others do where performance or throughput become an issue.

We are...

Please post your logs.

Here is a starting point with some basics included for you:

IF EXISTS ( SELECT *

FROM ...

Eric M Russell (8/22/2016)

---

My understanding is that "adaptive data modeling" is basically the opposite of normalization. It's where you are not modeling entities upfront using fixed attributes, but rather have...

+1 SQL Prompt

It would be pricey if it were only providing code formatting but it is much much more than that. It is worth every penny in my opinion.

+1 for SQL Prompt

Recently rolled out copies to entire dev team including standard formatting styles to promote consistency across entire codebase.

Try this out...ended up using DENSE_RANK instead of ROW_NUMBER in order to address dupe Styles:

with cte as (

select DENSE_RANK() over (partition by Brand, Model order by Style) as brand_model_style_ordinal,

*...

Looks like you've got the pivot working to get to the colors into columns. To get to the Style try introducing a ROW_NUMBER into the mix and using that to...

smiF (8/9/2016)

---

I have 4 separate tables that are related to each other. I want to return a count of each record in a table. Yet, return the answer in one...

Any chance you could post your data as a CREATE TABLE followed by a series of INSERT statements so I can setup a sandbox on my side?

Your expected results per...

joe 92217 (8/9/2016)

---

Hi everyone -

I'm trying to debug a problem that occurred in our application that involved a query that ran causing some unexpected updates.

The event occurred about a week...

PJ_SQL (5/19/2016)

---

I have one column:

SLVER CREEK DR

3RD ST

S OAK GATE LN

ABCSDGFDG LN

Turtle WnhhkjT

E Royal Street

Values that need to be in

ColA : S,E

ColB : SILVER CREEK, 3rd, OAK GATE,ABCSDGFDG...

Thank you for the reply.

My requirement changed a bit:

I have one column:

SLVER CREEK DR

3RD ST

S OAK GATE LN

ABCSDGFDG LN

Turtle WnhhkjT

I need the above data split into three columns:

ColA ...

re: "and more", PolyBase and R analytics integration are very exciting features to me personally that will expand the data platform and its reach within enterprise environments.