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.

Luckily it was a minor issue. When you select...

tom.groszko (5/2/2016)

---

Did you ever find a PBM way to do this.

I have been unable to find any facet that looks at code.

The facet Multipart Name only looks at the...