bcp exports the results of a table, view or query, not the results of a procedure execution.

You'll need to capture the results of the proc into a table,...

Great, I'm very glad it helped!

Much harder without consumable sample data, but something like below should be really close at least.  I'm not 100% sure on the specific end date determination you want, but you...

All taxing authorities I know of at least allow rounding of tax amounts, and afaik all businesses do it.  After all, it's ultimately extra money to them to charge more...

I don't believe there is, since the value is rounded up.  You can calc the rate that would produce the rounded-up amount, but I can't see how  you would ever...

I don't really see the need for the overhead and potential issues of reading the sys.all_columns view.

;WITH
cteTally10 AS (
  SELECT * FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0))...

SELECT FieldName,
  MAX(CASE WHEN ID = 2 THEN RecordCount END) AS OldCount,
  MAX(CASE WHEN ID = 1 THEN RecordCount END) AS NewCount,
  MAX(CASE WHEN...

Prob not "the best way", but I think it works:

select ssalesid, salesname, salesamount_split, rank
from (
  select 1 as ssalesid, 'cust1' as salesname, cast(101.50...

Are they covering indexes?  Just having a nonclustered index on a joining column(s) is often not useful for SQL, unless that index fully covers the query.

I have had...

I prefer to use CROSS APPLY to assign an alias name, like below.  Just to show the capability, I also used a CROSS APPLY to get the CONCAT'd column value:...

If the app is going to be reading the entire table anyway, if possible, use a clustered columnstore index.

Interesting article which brought up a great point about things to consider when writing code.

But you need to be fair to the "combined" code version.  So let me...

If you want blanks rather than NULL, then:

CASE WHEN ALTotalUnits / TotalProfiledHours >= 3 THEN CAST(ALTotalUnits AS varchar(30)) ELSE '' END AS [Higher than 3 Weeks],
CASE WHEN...