Now, how about your code that isn't working? It would be helpful to see what you have done sofar.

Please read the first article in my signature block about asking for help. Follow the instructions in that article on what and how to post to get the best...

sqluser (8/5/2009)

---

1. If all the fldCID (101,102 for fldCID = 1) are available in AT then i have to get the maximum fldDates fldMID.

In this example only...

Can you post your code that you are have problems with?

Eswin (7/17/2009)

---

Hi Expertz

These procedures are blocking other processes.

Lock created is "LOCK_M_S".

In Most case the blocking is started from the Host_A which at that moment is exec "SP_UNPREPARE" and the...

So, have you tried setting MAXDOP to 1 on the query in your stored procedure? Did it help?

You should still explicitly name the columns in the SELECT clause. Not that it may cause problems, it is just that is, for many of us, a bast practice.

I may have missed it, but you will want to ensure that @RESULT is initialized to zero (0) before you start the update.

Is the Q: drive a mapped drive or a local drive on the server? If a mapped drive to a network share, you may want to change the path...

Sorry, you can't insert data into two separate tables with one insert statement. You'll need to do it in two steps.

Please tell me you aren't using the * in the SELECT clause in your production code. You really should explicitly declare the columns you are returning in a select...

Please take the sample data you provided, and create the expected output that should be generated by the query. Please don't just describe the output, show use what it...

Jan Van der Eecken (8/4/2009)

---

Thinking of Kassondra as well, Lynn, and wishing her good luck. But as you should know, she's being taken care of by pro's who will not...

Having found out you had double posted this request for help. I redirected everyone to this thread. Unfortunately, I failed to notice that one thread was in a SQL...

Curious why you have double posted this request for help? You now have two threads going with different people answering the same question and those in one thread not...