Hey,

I have Windows 10 running SQL Server Express 64-bit and I purchased SQL Server 2016 Standard (genuine) key. I want to upgrade and I'm having difficulty figuring out...

Passed the initial screening and now have a SQL interview. Dabbled with SQL for a few months now but there are a lot of resources that I can...

@Chrissy321...

Did that last hint help you succeed?

To my point - if you are using datetime or datetime2 and need to be accurate across time zones, then you must have some method of determining the offset...

p.s.  The links in the signature lines of both Mike and I will get you better/actual coded answers more quickly.

Personally and generally, I think Date Dimension tables are usually overrated for such things.  Using things like GROUP BY with ROLLUP, CUBE, or GROUPING SETs is much more effective.  You...

You also say you always want to show the largest positive number first.  To be honest, that doesn't make any sense because it seems to provide no value in what...

Consider people that have no idea about your data.  We don't know things like how a "unique trip" is identified, what defines a "corresponding couple" of stations, etc.  You'll also...

Here is an example where it goes from a NULL value to a Positive number then a Negative number in a three hour period.

WD 1116.0 (HILINE)1413HI...

Hi Jeff,

First thank you for responding,

The first column is the name of the locations. some are represented as a decimal  representing the mile post of a location, however it...

Heh... when I read through this, my thought was "This is one of the primary reasons I don't use SSIS". 😀

The next step of Piet's recommendation can be found in the documentation for SQL Server.  Look for "Partitioned VIEWS".

Your test data appears to contain two different line types, the rows for "E Hazen" being different than the rest.  Save us some time and tell us which set of...

You're welcome and thank you for the feedback.

The articles are based on "pivoting" numeric values but you can do like Kaj suggested and use Min or Max to pivot text. ...

You added "columns" to the CROSS APPLY and changed the width of some but you didn't change the substring values that look like this...

,11,10)
,21,10)
,11,10)
,21,10)