@ sgmunson

October 2, 2018 at 8:21 am

#2007701

@

October 2, 2018 at 7:46 am

#2007692

@ Thom A - The alias after FROM (ConnectoryStore AS ConnectoryStore) is an artifact from throwing "hail mary" passes to the end-zone (American Football term) to try and get rid...

Beautiful! Thank you! I will use it!

I ran your simplified statement and it ran fine. No Error reporting though

--sp_Create_Accounts04 -

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

-- SET NOCOUNT ON added to prevent extra result sets from interfering...

I noticed you mentioned "core"... But I wasn't sure if it might deal with the error aspect.

Thank you so much for getting me up to speed. I wish I could...

How would this report the error?

BEGIN TRANSACTION

BEGIN TRY

Insert ...

Insert ...

Delete...

COMMIT TRANSACTION

END TRY

BEGIN CATCH

ROLLBACK TRANSACTION

END CATCH

Thank you.

SQL Server doesn't let me set break points like Visual Studio. When there an error, the line numbers are usually inaccurate and this makes it pretty hard to debug,...

Why all the "Why's"???

Like I said... this is my first T SQL statement!

I wanted to place 2 INSERT's and one DELETE. If they didn't work, I want to abort...

Why am I using @@Error? Because this is my first Transact statment and I don't know any better... ;>

This is what I have right now and it is working... Please,...

I noticed I named my Error section incorrectly when I was pasting the code.

Here the revised:

Error:

SELECT @ErrorMsg = 'Error: ' + str(@ErrorNum)

PRINT @ErrorMsg

ROLLBACK TRANSACTION BeforeInserts

RETURN

Thank you to all who...