DECLARE @Var MONEY

SET @Var = 12999

SELECT @Var, ROUND(@var, -3)

You're using cursor to populate a table.

But you never return the data from that table.

I cannot find a SELECT statement which would return data for bcp

The last SELECT from your SP must be from a # table.

BCP evaluates output by recompiling procedure, before it's executed.

At the time of compilation temp table does not exist yet,...

Try it this way:

....

FROM InvoicedAndPaid as aa

RIGHT JOIN SalesReporting.dbo.team_members as bb on rtrim(aa.CustomText01) = rtrim(bb.specialist_name)

....

You may wish to convert hierarchy into relationship.

Create Table #StockSuperceded

(StockID_Superceeded int,

StockID_SupercededWith int,

StepNo smallint -- assuming there won't be more than 32k steps in the process :-)

)

Then...

SELECT *

INTO ##temp

FROM [Table name]

Comparing strings may be VERY, let's say, misleading.

Compare following 3 addresses:

'7356 BRIDALE BLVD'

'73/56 BRIDALE BLVD'

'Apt. 73, Unit 56, BRIDALE Boulevard'

Which ones will be closest by string comparison?

And how does it...

Run proc2.

It's totally wrong use of the function.

Read BOL about correct ways to use it.

To make Nate's solution 1 step shorter:

SET @ItemID = NULL -- needed only if there is a loop for multiple invoices

SELECT @ItemID = ISNULL(@ItemID + ' zz ',...

OK, I guiess SSMS is not that user-friendly as Query Analyzer user to be.

So sad there is no downgrading option here...

😉

True, sp_makewebtask is replaced with SSRS...

You may wish to use sp_makewebtask to build an HTML file from your query.

Then you may send that file as a message body.

Not sure if xp_smtp_sendmail can do this, never...

Check out "Cross-Tab Reports" topic in BOL.

Is it what do you need?