Is it possible to exit the proc without falling thru to the DROP TABLE? What about the start of the proc? If the temp table already exists, does the...

What about this?:

Update A Set A.[Fname] = B.[Fname]
  from [Reporting].[dbo].[D02_CallLog] A 
  inner join [Reporting].[dbo].[D02_CallLog] B
    on A.[CallID] = B.[CallID]
 ...

UPDATE a
    SET a.Fname=b.Fname
   FROM [dbo].[D2_CallLog] a
  CROSS APPLY(SELECT TOP(1) *
          ...

As a guy who constantly advocates for ANSI/ISO standards, I would like to point out that the CONCAT is not SQL but local dialect. The correct syntax is in...

IIF is so unlike other other functions and expressions in SQL that it shouldn't be there.  That is, nowhere else in SQL does it enclose conditions and the...

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...