Cool idea. Will have to add to my snippets.

This seems like an awfully complicated way to handle getting more than record. Why don't you just pass the plates that the user wants? The way you built this you...

Let your troubles be a good example and reason why you should store datetime data in a datetime datatype. Datetime information in NOT string data. It is datetime data. You...

OK something like this should give you a decent example. This will keep your entries grouped together but you WILL have to figure out what column in your source table...

That is because the sequence numbers were hard coded in the insert that Chris wrote. I believe you want to maintain the same kind of sequence you had in the...

Looks like you forgot to finish your post...

/facepalm

totally missed this was Intranet. That's what I get for responding for finishing my first cup of coffee. Yes internally you absolutely can get the current user. I am going...

The app pool is the user that is logged in. The web server has no way to know the username of the client that is connecting. That would be a...

You can't create a database and reference it in the same stored procedure. You can only use a single batch within a stored procedure and your database will not exist...

Oh my!!! There is so much inefficient and not accurate code in here.

Let's start here.

SELECT

@rate_type_home = rate_type_home, --Get...

Oh man you so don't want to use a cursor here. I am pretty swamped at the moment but I can help later today if nobody else jumps in.

Yeah why would you create a stored procedure to create a permanent table? You can't run your stored procedure more than once. You probably should be using a temp table...

And what exactly did you contribute? A lot of arrogance and confrontational nonsense.

Here is your post with all of the arrogant and non contributing drivel strikethrough

There is nothing advanced or...

LOL We are all guilty of over thinking. It is part of what makes our type of people the way we are. If we didn't try to innovate we would...

If you have cascading deletes setup on your relationships just delete the parent. If you don't then you will have to delete the records from ALL the children first and...