Please also post DDL for any indexes and constraints that you have on the tables.

John

So you want to exclude both rows?  Please add Thom's rows and mine (below) to your sample data and show us what would be your expected results.

INSERT...

Looks like a job for the LAG or LEAD function, partitioned by ContSeqNo.  Please post your table DDL in the form of a CREATE TABLE statement, your sample data in...

Search this site for a splitter function to split the string into individual elements.  Then convert each element to an integer - here's a page with a few...

Steve

You're probably going to have to reverse engineer it from the catalog views.  sys partitions is a good place to start.  You might even find someone who's done...

You haven't built your string properly, and like Sue said, you're not even executing it.  I don't know much about VB, so this is almost pseudo-code, but try this:

That isn't even going to compile, since you haven't declared @FirstName and @LastName.  Also, please post the definition of stored_procedure_to_be_exec_first_time_only.

Do you only want stored_procedure_to_be_exec_first_time_only to be executed once - ever? ...

Which stored procedure do you want to restrict to a single execution - the calling one, or the called one?  And what do you mean by "first Time", given that...

How do you decide which process should run the stored procedure?  What are these processes - are they from the application?  Why do you need to do this, by the...

Prasanna

I'm not sure why you're getting that error message.  But you need to use ALTER LOGIN instead of CREATE LOGIN, since the sa login already exists. - then...

If the stored procedure is located on Sever A then specifying ServerB in your four-part name isn't going to get you anywhere.  You can get this to work by (a)...

Since INSERT is your only course of action (part from doing nothing), I don't think I'd bother with the MERGE statement.  Try something like this.  If it doesn't work, it...