assuming you are using US formats you can do

select convert(decimal(10, 2), parse('$16,500.50' as money using 'en-US'))

for those who avoid twitter (like me) https://www.inverse.com/entertainment/babylon-5-reboot-cast-release-date-2023

I'm not sure how server specs would translate to different behavior in the query engine.  I did actually verify that the problem is version- specific.  And a calculation with...

even on the same version but with different server specs it can return different results - I would not consider it a bug but rather a consequence of using float...

I want more of B5... for work I would like those that don't understand the technology would include and listen to those that do in their discussions.

multiple issues there.

Union on its own needs to sort the data to remove duplicates - adding to this you have identity_insert on which has its own issues.

and (probably the worst)...

to use UTF8 in SQL 2019 NVARCHAR is not required (see https://docs.microsoft.com/en-us/sql/relational-databases/collations/collation-and-unicode-support?view=sql-server-ver16#Unicode_Defn) - but increasing the size of the existing varchar MAY be required.

have a look at https://techcommunity.microsoft.com/t5/sql-server-blog/introducing-utf-8-support-for-sql-server/ba-p/734928

example of what I do on one of my databases with regards to users and groupmembership

note the detail of formatting the dates in a very specific format as well as...

• This reply was modified 3 years, 2 months ago by frederico_fonseca.

Can you clarify how...

Maybe.. maybe not.

one of my main big tables (clustered columnstore) is partitioned as well - but each partition has 3 Billion...

Columnstore is good for aggregation SQL's - not for plain retrieval of data but 45 min still looks very bad.

on your case I would be interested in seeing how it...

if you get the files in Excel and convert to CSV then it would be better if you define the format of the dates at that point - assuming the...

You also need to consider licencing costs for MSSQL and they can be very complicated.  From memory the minumum licence is 4 cores and then in multiples of 2...

there is nothing we can say to help you there - all those values are specific to your own AD structure. It can be whatever your admins decided it would...

why don't you try it? should be rather easy for you to set up a test case on your own instead of spending time asking if it is possible.

you even...