Although this does not address your question, I'd be tempted to try out this alternative syntax:

WHERE NOT EXISTS
(
    SELECT x.status
    ...

WHERE sent_rowid is null or vendor = @vendor_param

?

Frederico's message is spot on, as usual!

In my opinion, Excel should almost never be used to view *sv files, because as part of its parsing, it tends to display values...

If your databases are fully source-controlled, it should be possible to simply deploy them from the relevant branch. The act of deploying will take care of most of the DDL...

Dynamic SQL is one way of creating a variable SELECT statement that can be executed.

• This reply was modified 1 years, 2 months ago by Phil Parkin.

Thanks Phil. I will check this.

One more query related to this. In the screenshot you can see that "save my password" is checked for the user "SA". How can...

Different people will do things in different ways, as it depends on how you want to work together, how many developers there are and how many projects there are.

I work...

If you do not have a server called CCSQL, I think it may be an alias to a server.

Read more about aliases here:

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/create-or-delete-a-server-alias-for-use-by-a-client?view=sql-server-ver16

If you don't need or want to...

Can you provide a screen shot, as I'm not sure exactly what you mean?

Not sure what that is, but try pressing 'Parse' (CTRL/F5) on it and you'll see that it doesn't.

The code fragment I posted would not create that error. Can you post the entire text of the query which is giving that error?

Your code is different from what I suggested. In particular, you changed <> to 'Like'.

SELECT ...
FROM sometables
WHERE t4.ReturnDate >= DATEADD (yy, -2, DATEADD (yy, DATEDIFF (yy, 0,...

These are the rows that did not import properly:

and here are the originals (taken from the CSV file)

So now you can see why they...

• This reply was modified 1 years, 2 months ago by Phil Parkin.

I just tried this and it imported quite easily.

Assuming you're in SQL Server Management Studio and want to import the data into a new table in a database which already...

If the following query produces more than one result, that is your problem – you cannot update a single value to a multi-valued result set:

SELECT DISTINCT
 ...