WHERE <date column> >= DATEADD(day,-7,GETDATE()) AND <date column> <= GETDATE()

Mind you, you may need to do some tweaking to those to make sure you are getting the EXACT...

You are right there The Dixie Flatline... the ROLLBACK rolls back all transactions.

Not sure why I thought it only did the most recent one.

COMMITs happen per transaction though.  So if...

Unicode is basically special characters OR non-english characters.  If it is all characters you can see on your keyboard and you have a USA keyboard layout, then you likely don't...

One way (not ideal) to do it would be to have the excel have the "corrected" data in worksheet 1.  Worksheet 2 has a connection to SQL and pulls in...

I think it really depends on the requirements, the source data, and the expected output.

What I mean is if you are asking for 1 date parameter and then it uses...

If the max length is 450 characters, VARCHAR(MAX) is going to be overkill.  Even VARCHAR(1000) would be overkill, but would give you wiggle room.  But it depends too.  If your...

What is in your SQL error log (ie not the windows error log)?

My guess (without seeing your system and seeing ONLY what you posted) is that there is some sort...

One thing to note about Paige031's comment is that if you use the + operator on a VARCHAR and an INT column and the VARCHAR cannot be converted to INT,...

The documents you linked say that it MUST be CHAR or VARCHAR or be able to be implicitly converted to those datatypes.  According to this website:

https://www.sqlshack.com/implicit-conversion-in-sql-server/

The implicit conversion for CHAR...

Basically, the IMPLICIT transaction being turned on means you are going to need 1 additional "COMMIT/ROLLBACK" in your statement.  IMPLICIT TRANSACTIONS being turned on is like putting an extra "BEGIN...

The error is coming from the Snowflake ODBC connector.  I would check that it is configured the same on the server where SQL is hosted and on your visual studio...

Like Pietlinden, I am not sure what you are trying to do, but one way you could do what you are asking would be with a cursors and a while...

I agree with you ScottPletcher... I was just using examples (poorly) and bad terminology.  By "unhappy" I just meant that performance would likely not be great.  It is more that...

The "media" folder would be the folder that contains the installation media.  So wherever you are running "setup.exe" from is the folder you would use for that.

IF you don't have...

You should be able to use the default installation folder UNLESS it is asking for the installation media folder in which case you will need to point it to your...