Hi

Which service pack on SQL Server?

Thanks -- Vijaya Kadiyala

http://www.dotnetvj.com

Hi

I would go with Ramesh's solution because one it has Count(*) in outer query and second he is using Analytical functions.

Thanks -- Vijaya Kadiyala

http://www.dotnetvj.com

Hi

You can use BEGIN TRANSACTION things like this but this may not help you in all the ways. Especially when you have batch updates then you want to put these...

Hi

You can also check out the below link..i did explained in very detailed way.

http://www.dotnetvj.com/2009/03/merge-in-sql-server-2005.html

Thanks -- Vijaya Kadiyala

Hi

I agree with you guys on HAVING clause. It took long time even for me also to figure it out. Would there be any performance issue if we use the...

Hi

Check out the below link

http://www.dotnetvj.com/2009/03/foreign-key-and-primary-key-in-sql.html

Thanks -- Vijaya Kadiyala

http://www.dotnetvj.com

Hi

Check out the below link

http://sqlserver-tips.blogspot.com/2006/09/mimicking-merge-statement-in-sql.html

Thanks -- Vijaya Kadiyala

http://www.dotnetvj.com

You can even use COALESCE.

Check out the below link

http://www.sqlteam.com/article/using-coalesce-to-build-comma-delimited-string

Thanks

Vijaya Kadiyala

http://dotnetvj.blogspot.com

HI

Are you using any stored procedure to do it?? or directly have these SQLs in Application code.??

Thanks

Vijaya Kadiyala

http://dotnetvj.blogspot.com

I Appreciate the way microsoft changed the pattern of this exam, So Now one has to use SSMS in order to clear the exam as opposed to going through the...

Hi

What are you expecting of this query??

select count(*) from policy;

Thanks -- Vijaya Kadiyala

http://dotnetvj.blogspot.com

Its also depends on where you want to use this!! if it in the application then i would recomed to use View.

Thanks -- Vijaya Kadiyala

http://dotnetvj.blogspot.com

Hi

Normally what we do is, we add Row_Version column to the table where we are expecting DML operations. When we query and display the data in the application we will...

Hi

Check out the below link

http://msdn.microsoft.com/en-us/library/ms144260.aspx

Thanks -- Vijaya Kadiyala

http://dotnetvj.blogspot.com

Hi

can you give us the volume of the data in the tables along with the Execution plan.

How much it is taking right now? How the end users are going to...