The question is. Do you manage the transactions inside the SQL code or from the client?

You can not get that connection back. If you issued a command and the SQL...

The server will timeout the connection and rollback the transaction.

This function should work for you. The advantage over GSquared's solution is - no dynamic SQL and you can use it inline to get as many records as you want...

Your code might be working but the last UPDATE is updating ALL the records not the last inserted only. Your WHERE caluse is basically saying WHERE 1 = 1.

Create a UDF.

Inside look for each string 'Week', 'day', 'month' individually , find the number of units per each and add them up individually.

I am off to a meeting so...

I think you meant to do this.

SET @CODE = SCOPE_IDENTITY()

SELECT @CODE AS EducationCodeidno

UPDATE tEDUCATION_CODES set EDucationCodedomainIdno = EducationCodeidno where Educationcodeidno = @CODE

OK. Few comments.

The EducationCode and EducationCodeType fields require a non empty string. Are you sure you passing some value into the @EducationCodeDesc parameter?

The procedure code you posted. Is...

Run this and post what you got

SELECT SC.name, SC.xtype, SC.length, SC.domain , C.text

FROM syscolumns SC

INNER JOIN sysobjects SO ON SC.id = SO.ID

AND SO.name = 'tEDUCATION_CODES'

LEFT OUTER JOIN syscomments C ON...

Lucky you. I found out the hard way. 😀

On another note.

You should not use @@IDENTITY, use SCOPE_IDENTITY instead.

The C# should deal with the datetime datatype from the Db correctly if you store the data in datetime objects. For display purposes you should use the proper ToString... methods....

Jeff Moden (4/23/2009)

---

Muhammad Kashif Azeem (4/23/2009)

---

O.k Jeff you are specialize in efficient stored procedure designing. We will chosen you to design good stored Procedures. But we won't give you complete...

Outsouring is good for economy.

It works the same way as all products. I do not know if you noticed but the driving force is buy more, use more, etc. Most...

Muhammad Kashif Azeem (4/23/2009)

---

O.k Jeff you are specialize in efficient stored procedure designing. We will chosen you to design good stored Procedures. But we won't give you complete project. Because...

Really wierd.

I tired to reproduce the issue on my SQL Express box and the first time it worked (I mean I was able to reproduce the problem).

Now I can...