First - you need a table of categories - with a...

According to your sample data and results, the "Answer" you marked is not correct.  For example, you stated that '10000' should return a 1 -- "Anything between 00000 to...

• This reply was modified 4 years, 5 months ago by Jeffrey Williams.

No - I don't have an example available, but there are many available if you search for C# start process.

Just a further clarification - DISTINCT is not needed here, because the IN operator doesn't care if there are duplicates.  It just looks for a matching value in the list.

I...

I have to disagree with Brian - the first step is to review why you are calling out to Powershell in the first place.  Based on the snippet of code...

What is the change that needs to be made?  Normally - adding a column to a table shouldn't require changing any other code and shouldn't require modifying the view.  If...

Stupid question, but why are some people use a low fill factor as 70 or 80%, I'm usually fine with something as 95-98 (or even 100 if it is...

You need to replicate the logins to replica 1 & 3 (DR) - those logins will be needed on the DR node if you ever fail over.  For reporting logins...

FYI - the cast by itself will round the value - so: Select cast(0.57 As decimal(3,0)) will return 1 (not 1.00 though).

Both ROUND and CAST to a numeric will round the number up or down - the difference will be the value returned.  Using CAST will return 6 digits to the...

I like the cross apply, but not sure it's needed here.

Going back to the original, asita, is the goal to bucket rows for a report of some sort? what's...

Or...

 Select *
      , ZipRange = (z.ZIP / 10000) + 1
   From #ZIPs       ...

Create a table with the zip code ranges - then use an outer/cross apply to lookup the range.  Or use a CTE to create a table with the range and...

• This reply was modified 4 years, 5 months ago by Jeffrey Williams.

It is quite normal on other products to not allow auto growth to occur in the database files or tablespaces.  Monitoring of those files and extending them when needed is...

Interesting - there was a similar issue recently where the individual 'restored' the system databases after building up the system.  The method used for restoring wasn't a standard method and...