ensure the file is a correctly built CSV file - if it is then you can load it using the format=CSV above - if it not then...

ensure the file is a correctly built CSV file - if it is then you can load it using the format=CSV above - if it not then get whoever...

I tried a few values and the outcome is the same.  The file...

I came across OPENROWSET.  This looks promising but I have never used it before.  Can this be used for my purpose?  If yes, how would I use it?  I am...

There is probably a non-printable character in it.

CREATE TABLE #DIVIDENDS_NEW
(
[DIVIDEND_AMOUNT] [varchar](15) NULL
);

insert into #DIVIDENDS_NEW select NULL;
insert into #DIVIDENDS_NEW select '5';
insert into #DIVIDENDS_NEW select CHAR(10); /* invisible...

This is great.  It works.  Thank you so much!

I re-wrote my code with an IF statement and that solved the issue.

I clarified my original post.  Not sure if you saw it or not when you replied.

I did think about TRY/CATCH but not really sure how I can...

I gave the proposed logic CASE but I am open to anything.  If code has an error then return NULL else run the code

I was playing around with the query.  I figured out the problem.  The query didn't like the alias.  Once I removed the alias then it worked.  That is so odd...

Thank you so much!  it works now!!

Is anyone able to help me with this?

I used DBCC SHRINKFILE (1,0) to shrink the MDF file.  The size of the MDF file is about 20GB.  How long should this command take to run?  Should it be...

• This reply was modified 5 months, 3 weeks ago by water490.

I found queries to help

https://learn.microsoft.com/en-us/sql/relational-databases/databases/display-data-and-log-space-information-for-a-database?view=sql-server-ver16

How do I interpret the results?  I ran sp_spaceused to get this:

The MDF is close to 37GB and LDF is close...

Thanks for the reply.  Very helpful.

Is there a way to look at the system to see why the increase is happening?  A more "scientific" answer to figure out the root...

• This reply was modified 5 months, 4 weeks ago by water490. Reason: fixed a typo