I think something like this should do. Use a derived table and then left join with a where null condition to find records not joined.

select t.CodClient,t.Name, (t.Address2 +...

Can you explain exactly what you need?

SQL will handle multiple updates automatically by locking the table and processing records based on the ACID properties. So I think...

Self join the table on ClientName, Product, and ArcDate with a date function like ArcDate = DATEADD(m,-1,ArcDate). Then select the distinct record set.

SELECT DISTINCT

ClientName,

Product,

A.ArcDate - B.ArcDate

FROM Tbl A...

I don't know your answer, but somethign you might want to look at is the property for LogonServer. If you run the set command it will show you the...

Primary difference is that when the .bat file is executed from SQL sp_cmdshell is that it runs under the context of the SQL Service account (unless your using a proxy...

If you have multiple instances make sure SQL Browser Service is running as I believe it is required to access other instances than the default one. You should also...

I think this points out how there is not one way to do things. I agree with rbarryyoung the most. There are really two options. We could...

I agree with the other individuals that you might be better suited to use two fields of datetime data type and then look at the differences.

If you want to do...

I would look at the isdate() in the where clause. Is it possible that the query evaluates the first condition and fails, before it eliminates the isdate() criteria. ...

Thanks for answering the questions. I changed the value and it changed the running value as well. So seems no restart is needed.

I will take a look at...

To select from another database use a fully qualified name Database.Owner.Table as long as it resides on the same server and your account has access. If its on another...

Might be missing something... but can you do something like this?

select z,

min(case code1 when 'xy' then date else null end),

max(case code1 when 'zx' then date else null end)

from table

where zone...

I don't think that there is a clear cut answer to your question. It will depend on the queries you are issuing, the data contained in the tables, existing...

The MAX() and other functions need a value to evaluate. The nature of NULL is that it is undefined. So if you have three records with quantities...

Having the groupby include the datemonth() will cause an extra record for each month where there is data. I think you just need to get rid of that logic.