@sets4life

Are you still there?  If so, see my previous post.

Hi All

Trying to do a query to find out how old are the cpu on device. We do have a way of doing it but it involves manual step...

According to the OPs profile, no.  In fact, this appears to be the first and only question they've posted.

When I do things like this, I return separate columns for the properties I wish to control (font, bold, colour etc) and then assign those columns to the relevant...

One possibility for those is  a bit shorter...

NULLIF(A.CALC_Date_EOIReceived,'1900-01-01 00:00:00.000') AS [Date Req Created]
NULLIF(A.CALC_Date_EOIReceived,'1900-01-01 00:00:00.000') AS [Date Initiated]

If we could see the rest of the code, we could...

I'm looking at a career change. I have bachelors degree in healthcare management and pre counseling. My mental health is going down the drain and do not think I...

I'll also tell you that a lot of companies aren't going to send you a database backup because there's a whole lot of stuff in a backup that they might...

With a small tweak, the method in the following article is what I use for such bleedovers.  It's NOT a short article because it actually explains how to think about...

Hi there,

I am looking to find some very good beginner resources for SQL server 2016 as we have to use that at work. I dont have much experience with...

I don't know what your stored procedure looks like but, if you need to compare every column of every row to all the other rows, then create a hash of...

All true and thanks for posting the examples.

Just to be sure though (for any newbies that might be reading this), that's not what I was talking about in my previous...

Lordy.  I agree with the others.  Using a decade old version of SQL Express instead of the current version or at least previous version of SQL server of the SQL...

Hi Tony, and welcome aboard!

Just to add to your explanation, a CROSS JOIN can also be used as a massive, super fast  "Pseudo Cursor" to replace <<insert drum roll here>>...

While this is all very interesting, I have to ask the question... Have you actually called the software vendor to tell them of your problem and to see what they...

Even with the columnstore thing, the original issue on this thread has never been solved.  What made the old query suddenly perform so poorly when the database was moved to...