Phil Parkin (7/23/2012)

---

Not sure I...

I hope the below mentioned query will satisfy your request

DELETEord

FROMOrders ord

LEFT OUTER JOINCustomers c

ONord.CustomerID = c.CustomerID

ANDc.FirstName = 'vikash'

WHEREc.CustomerID IS NULL

Edit: Edited the incorrect code

forsqlserver (7/23/2012)

---

Hi vikash,

In my case I want to delete those data which is not selecting in below join any Help..

DELETE ord FROM Orders ord INNER JOIN Customers c(nolock) ON ord.CustomerID...

You cannot use a WHILE loop to solve this problem, use CROSS TABS instead

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

http://www.sqlservercentral.com/articles/T-SQL/63681/

Cross Tabs and Pivots, Part 2 -...

One of the articles that helped me when I was faced with a similar issue

http://www.simple-talk.com/sql/database-administration/partitioned-tables-in-sql-server-2005/

Sorry. If its really that urgent, you would not have wasted time by cross posting again and again.

Did you read the...

This is what I got from Books Online

When a parameter of the function has a default value, the keyword DEFAULT must be specified when the function is called to retrieve...

The below article by Wayne Sheffield might be of help to you

Comparing Table Variables with Temporary Tables

http://www.sqlservercentral.com/articles/Temporary+Tables/66720/

In that case, please post your query in appropriate forum

There is a separate forum for SQL Server 7, 2000

Also note that people helping you...

I think you are talking about the computed column in SQL Server

You cannot achieve the desired result using computed columns

If trigger is not applicable, then there is only one option

Step...

In that case CROSS TABS is probably...

The below articles might also help you to get started

Finding the Causes of Poor Performance in SQL Server, Part 1

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

Finding the causes of poor performance in SQL Server, Part 2

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

raghuldrag (7/19/2012)

---

hi ,

i got the answer finally

select account_no,

sum(case when trans ='Cr' then amount else 0 end) "Credit",

sum(case when trans ='Dr' then amount else 0...

Please provide DDL of the tables involved, some sample data and expected results

If you don't know how to do this, check the link in my signature

Can you also provide us the expected results based on your sample data?