Back in the times when I started as a junior SQL developer I faced pretty much identical situation.

There was a Time-and-Attendance match task, which had a solution implemented by 3...

• This reply was modified 4 years, 3 months ago by  Sergiy.

So, the issue is actually in .Net code.

Nothing to do with an SP or any other part of SQL Server.

You mentioned something about using commas instead of dots. Comma in...

I don't think we need 2 calls to Tally function here.

If join parsed lists of names through Tally then we need only 1 instance of it.

I also use my

Decimal should be fine. As long if it’s really decimal.

can you output that decimal value to console right before calling the SP?

OK, I was not asking how the value looks in the grid view.

You're passing to the procedure the value Invoice_Total as a decimal value - is it right?

Formatting is irrelevant...

Write Invoice_Total to console right before calling the procedure.

What's the value you can see?

Further on the Excel CSV quirks,  as all numbers are floating-point numbers in Excel, any manipulation of the cell value will result in the 15[n]+0[n]

😎

Create a CSV file

            
August 15, 2020 at 8:33 am
            
#3780683

            
            
                                                
        

The file is posted above:

12345678901234567890,MARCH1

I named it "FaultyImport.csv", but feel...

Use the correct syntax:

exec (@sql)

It takes less than 10 keystrokes to convert a column to text. (Ctrl + space, alt + 1, alt + C, t, t enter)

I'm getting the impression that you...

The import process is a different type of potatoes.

😎

OOXML and MOX, Open Office XML and Microsoft Open XML file standards are the same. I've tested around 17 different OOXML...

built a report from an SQL database for...

built a report from an SQL database for...

The table is over-indexed in multiple desperate attempts to fix performance issues caused by lousy design and bad choice of the clustered index.

When inserting a new row you add records...

built a report from an SQL database for a big...