not (invoice_cl in('INN1') and [Payment Status] = 'Unpaid')
= (invoice_cl not in('INN1') or [Payment Status] <> 'Unpaid')
= (invoice_cl <> 'INN1' or [Payment Status] <> 'Unpaid')

so the statement

            
March 2, 2021 at 12:41 am
            
#3851991

            
            
                                                
        

Have you tried "inner hash join" instead of "join"?

select tm.new_oid, a.aid, a.category, a.attrflag & ~@ATTRFLAG_FROM_TYPICAL_VALUE, a.attrStatusFlag, a.value
  from AttribInt as a
 inner hash join #tblMerge as...

Under the hood SQL Server converts an IIF to a CASE

Ideally you would just have the first column in...

begin transaction 

    select @v1 = max(c1)
    from log_test1 with(XLOCK)

    set @v2 = @v1 + 1

  ...

select store, SUM(Amount) [Total Purchase],COUNT(distinct a.Cust_ID) [Distinct Customer], z.x [Total Purchase of Distinct Customer]
from Transactions a
cross apply(select sum(Amount) x 
       ...

I don't think I understand what you want.

This query is one of the above with an order by added

-- What are the total purchase of those unique...

-- What are the total purchases made at each store.
select store,SUM(Amount)
from Transactions 
group by store

-- How many unique/distinct customers made purchases at each store.
select store,COUNT(distinct a.Cust_ID)
from Transactions...

The query you had was the one I originally put in before I edited it a few minutes later. So try this,...

select count(m.musical_genre_id) as 'Number of Rock Songs', r.artist_name
  from song s
 inner join album a 
         on s.album_id...

There is a thread on stackoverflow about this with various different solutions:

https://stackoverflow.com/questions/18598075/datetime-fields-from-sql-server-display-incorrectly-in-excel

SSMS proposed me to create a composite NC index on Date_deleted, group_id, last_name, firt_name. Does it mean that I can remove indexes on last_name and first_name and create the...

Dear Group:

I am not sure if this is a T-SQL / SSMS issue, or Excel, so if this is off-topic please accept my appologies.  I am hoping there is...

((1 OR 2) OR (6 OR 7 OR 8))  AND 3 AND 4 AND 5

Is exactly the same as:

(1 OR 2 OR 6 OR 7 OR 8)  AND 3 AND...

So we have this third party shipping system that is...well...user hostile at best. To add insult to injury for the users the system has been suffering increased performance problems...