One graceful solution could be for the vendor to address the issue they caused.  Another graceful way could be to rewrite the application so the DB Engine manages locks and...

Ok I updated the query so the ORDER BY is using the numeric 'wk_num' column instead of 'WeekNo' which is CHAR(3) and other slight changes too

with lead_cte...

• This reply was modified 3 years, 10 months ago by Steve Collins.

You could fill in the missing weeks by using the LEAD(WeekNo) function to determine start/end points of the ranges.  To expand rows across the ranges you could use the...

• This reply was modified 3 years, 10 months ago by Steve Collins.

Yes it's just an encoding.  How could one perform such an encoding without XML?  That's the hijacked topic 🙂  As an aside: I associated the encoding with a conversion because...

Something similar iiirc.  As I recall HASHBYTES were applied too.  It was to make offers which expired

This concatenates (a bunch of guid's and an expiration date) together and encodes to binary base 64 and converts the result to nvarchar.  The encoded token could be used in...

One area where it seems XML is required is for the conversion/encoding of strings to varbinary base 64.  Altho if there's newer way I'd be interested to hear about it

As frederico and Jeff have already explained the numeric value in the table has no display format of its own.  If you're ok with a type conversion (from numeric to...

'sysdate' is an Oracle function?  Idk the syntax doesn't look like SQL Server

A bit of a sidebar... I almost always avoid both EOMonth and anything else that is used to calculate the last day of the month because so many people...

Great information from ratback.  I totally agree about staying within the larger segments as being a good strategy.

The chart I always come back to and track is db-engines.com.  It attempts...

Here's a table valued function which takes as input a (2-part named: schema.name) stored procedure (as column type SYSNAME) and which produces a SQL script some of which could be...

Kind of an odd sentence.  RedGate is in the greater Microsoft cosmos as their...

Can't say anything without seeing the code

Checking back in here.  The OP generated the 15 minute data from the recursive CTE and that's all the data they currently have?  As an aside: a recursive CTE is...