will be there any limitations? my remote sql server 2005 is an...

2008 does not support backward compatability, so you can do this. You need to do the re work using visual studio 2005.

Hyderabad,India.

Nice article Geoff, really usefull

This code looks much simple than in the article

You can use VARCHAR(MAX) or NARCHAR(MAX) if you are using sql server 2005 and above.

Generally when you are inserting the comments from the front end you can use some validations...

select max(coursefees)-sum(fee.amount)

from feespaid fee,batch

where

substring(cast(fee.rollno as varchar(50)) ,1,2)=substring(cast(batchcode as varchar(50)),1,2) and

rollno = @prollno

group by rollno,batchcode

the above Query is returning more thatn one row for the @diff variable where it is permited...

Lowell (12/7/2010)

---

well first lets get rid of the cursor.

there is nothing a cursor does that a set based operation cannot do, and the set based would be a couple of...

Lowell (12/7/2010)

---

statistics most like is the culprit.

if your SSIS package is insertint/deleting/updating rows, and then calling the procedure, the statistics are probably very different than when the stored procedure was...

TRY/CATCH helps to write logic separate the action and error handling code in sql server.

if some action fails in the try block you can roll back it in the catch...

What is the logic in getting the desired values, i havn't find any diffrence in your table and the out put other than some change in the order.

apart from the above your code is also

having...

the solution...

Jeff Moden (11/30/2010)

---

autoexcrement (11/30/2010)

---

sharath.chalamgari (11/30/2010)

---

Simple and nice article,

some time back i was working on validating a column in the database and i came across this issue and we had...

you can update the column to 'YES' using the from clause and inner join. some thing like

update PmtTrn

set PmtTrn.column_yes = 'YES'

From PmtTrn

Inner Join AdjTrn

on AdjTrn.itrn = PmtTrn.itrn