Database

Use Try Catch block and in catch block write statement rollback tran this may work for you easily

Sorry for posting in the wrong area. I corrected this by post in the suggested area of Web Development. Thank you for correcting me. Evan

Oooh nasty So your app has not changed, now it comes down to your environment, you know all those lovely security and product updates courtesy of every vendor with software on your platform, one (or more) of them has probably changed something. I would think that rebuilding your install may make a difference. You may want to look at changing your references away from 'specific version' Never underestimate the power of human stupidity RAH

Instead of a computed column, use a normal column and use an after update/insert trigger on the table that calls your function and sets the column value for the row in question. You then also have the advantage of adding an index on this column. :) Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]

1: The connection string is Correct it comes from my webconfig 2: Can you give me more info on this one. Thanks 3: what Configuration needs to be there ? i have SQl 2005 installed and 2008 installed they both use the same port 4: i saw that links and i have Googled Thanks Vuyiswa Maseko, Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code. C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/

Try this: select * from tablename where (datediff(day, startdate, '23-Feb-2010') = 0) Adam

Try this: http://www.techonthenet.com/oracle/questions/find_pkeys.php[^]

Hi Mark, Thanks for your feedback, do you have an example of that? Is there not a constraint in sybase or something along those lines that I can apply to the column? Thanks again, Mel

try the below SELECT CONVERT(VARCHAR(10), GETDATE(), 103) AS [DD/MM/YYYY]

Can you post how you resolved it? Naina

Can i know the reason why you want to use Pivot? Using For XML PATH('') also you can get the same result. select emp_name + ', ' from tabble where condition for xml path('') Regards Naina Naina

mehrnoosh wrote: please explain more i am a beginner Then you need to do some research, there are plenty of resources on the web and you should have Books On Line (BOL) with your SQL Server. Use them, research instancename. I think you need to reinstall if you need to change the instance name but I'm not sure. Never underestimate the power of human stupidity RAH

Thank you Niladri it helped

Even you can try this declare @t table(field int) insert into @t select -2 union all select 5 union all select 4 union all select -1 select top 1 PositiveSum = (select SUM(field) from @t where field >0) ,NegetiveSum =(select SUM(field) from @t where field <0) from @t Output: PositiveSum NegetiveSum 9 -3 :) Niladri Biswas

Look into the group by clause. Select count(*), Customer, Status From Table Group By Customer, Status Never underestimate the power of human stupidity RAH

Hi It's good point, I want to show data in Crystal Report. Do you know any tutorial ?

You should immediately remedy the primary key issue if you have control of the database. I would add an identity field UserNo to user table and the appropriate fields and keys to the FK table(s). As Bob said you have made a fundamental error in data design, fix it and you no longer have the update problem. Never underestimate the power of human stupidity RAH

thank you