I'm starting to think the way I call my routines and functions could be refined. Maybe something like?....

Sub btnSubmit_OnClick()

Try

...

.to add...I suppose I could query the Max value of the PK. Say record 101 was the last one to be inserted. Then after the Insert takes place,...

Thanks Sean (and everyone else). I am catching on the .NET side by using Try / Catch. I've simply developed a habit to write the system...

http://blog.sqlauthority.com/2012/09/18/sql-server-ssms-automatically-generates-top-100-percent-in-query-designer/%5B/url%5D

...at least I'm not nuts....

I use a few different methods of creating a view. I can Right Click on the Views folder in SSMS and simply select New View. I can also...

I don't suppose anyone knows how to remove the TOP 100 PERCENT from SSMS default settings?

Sure. I would have expected SQL Server to do this when testing - especially when I defined the param as a Date type.

When I right click on the SP...

I was able to make it work by keying in for example, "20130528". Thanks for looking though.

Any other pointers or tips to practice by would be appreciated.

Yep. That was it. Thanks!

Good advice. Much appreciated. Will "CMA".

Thanks but don't have a choice in particular scenario....

Would you be so kind as to provide an example?

SalesmanID (PK)

SalesmanSSN (ype, it's the social)

FirstName

LastName

...etc...

That's what I'm finding out.

Thanks!

This is just the tip too.....

No idea?

Thanks for helping. Here is is all cleaned up:

USE [Database name]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[THIS SP NAME](

@Dummy varchar(20)

)

as

Exec [SP #1] 1

Exec [SP #2]

Exec [SP #3] 1

Exec [SP...