Hi,

I am looking for a sql help to generate one row per each sequental door_area, for a given employee, based on the sample data that looks like this:

Current Output:

To get sheer, blinding, speed.  It's the basic method that Pre-Aggregation through Indexed Views  work.  Of...

Hi All,

We are trying to delete data from a large 5TB log table. We are able to delete the data but that is not shown up in the free...

Hi Phil Parkin,

This is working on the sample data I created.

But If I apllied on my original table I am getting below error.

Invalid length parameter passed to the...

Ok......

I'm not sure the strength will help me as it's likely to...

At my new position, DISTINCT is the default for every query. Nobody knows why they do it.  There is a fairly large group who is 100% dedicated to creating...

Ok... let's all...

Jeff, Tally tables aren't working and this RBAR thing is RIDICULOUS....

Understood.  That's why I suggested that your first take on the subject is probably your best take.

To prevent any overlapping of old vs new, leave everything you currently have alone. ...

Instead of the normal long retort that proves you wrong that subject, I jump straight to the punchline this time......

Recommendation: When posting performance issues, please follow the guidelines posted in the article at the 2nd link in my signature line below.

Yep... there's the "can thing" and understood.

Since values from 000 thru 999 have already been distributed, we can't just use the simplicity of base 36 so I guess I'd do...

After migrating a massive number of documents for the AAIB and MAIB earlier in my career I became and avid watcher of Air Crash Investigation.  One fatal...

The reason why the code doesn't produce an error can be found in the execution plan.  Apparently, since SQL knows there's only 1 row, it never executes the...