Advise does not necessarily equal a solution.

Ready-made solutions which an OP can use but not...

I can't see the image.

Please also provide more sample data.

olibbhq (12/22/2016)

---

Hi,

What I would like to do is to return a running maximum and a running minimum

but with the added complexity that (sorting by rank ID) if the lower...

Tally table provides the power of a...

Use a number/tally/calendar table to iterate through the days.

http://www.sqlservercentral.com/articles/T-SQL/62867/

On a separate note, UNION eliminates duplicate rows, but your result sets are guaranteed unique (different dates). You are adding unnecessary...

Here you just scare people away....

I'll save Celko the effort here. NULL is not a valid action type. It is messing up your results because you are...

Use of Merge seems a good match for what you are asking.

However, I am baffled by what you are trying to accomplish with this. I can't think of any...

Don't think of the non-clustered PK as an index. It is just a constraint which...

In addition to Kevin's comments, you also have potential for unexpected results.

SELECT CAST(RTRIM( b.description ) AS FLOAT) AS ohproc,

...

Group by b.description

However many spaces you're trimming are still included when grouping....

This distinct is not necessary and has not effect on the result. It probably won't affect the query time as the optimizer is likely ignoring it, but better to...

Just another thought.

If you're needing space to convert the heap to a clustered index, drop any non-clustered indexes on the table first. NCIs also take up space and they'll...

SQL Learner - VKG (12/14/2016)

---

changing any heap into clustered index requires about same amount of space as that of table until that operations is completed. ... Conclusion : Clustered Index...

Igor Micev (12/12/2016)

---

If you have databases in Simple recovery model then check their Log files and potentially shrink them. But shrink the log files only, don't do that with the...

bucketlist50 (12/9/2016)

---

Declare @Counter int = 1;

with cte as (

SELECT @Counter as c,ASSET_NUM,[SHAPE].STPointN(@Counter).STAsText() as Points

FROM [dbo].[GEOMETRY_TABLE]

where ASSET_NUM =...