raghuldrag (7/27/2012)

---

account PR_Mons credit debit closinbal

=======================================

E2674 apr 3000 00000 -3000

R7890 jun ...

No. There is no way to update the NULL values in the table directly

You will have to write a query manually for all the 26 columns and document it

One option...

raghuldrag (7/26/2012)

---

create table report

(

account varchar(30),

trans char(30),

trans_date date,

amount number(50)

)

insert into report(account,trans,trans_date,amount) values('E2674','Cr','02apr02',300)

insert into report(account,trans,trans_date,amount) values('R7890','Dr','06jun11',5000)

insert into report(account,trans,trans_date,amount) values('E9700','Cr','7feb09',5000).......

insert into report(account,trans,trans_date,amount) values('R7890','Cr','06jun11',5900)

insert into report(account,trans,trans_date,amount) values('E9700','Dr','7feb09',8000)

now i need the output of display...

Welcome to SSC!!

You can try to Google "IDENTITY SQL Server"

I am sure you will get lots of information which can't be provided in a single forum

If you still have any...

raghuldrag (7/25/2012)

---

hi friend.

when i am using DATEPART() its shows the month number(april,4),But i need the month name..... while i m using DATENAME() function giving the same month number only...

xmozart.ryan (7/25/2012)

---

dwain.c (7/24/2012)

---

The code you posted is likely to perform better than any looping/dynamic script you can create.

If you just want to do it as an exercise, that's fine. ...

sankar.nandakumaran (7/25/2012)

---

Hi...

Thanks for the code , but here employee master table should contain only one row and emplioyee detail table can contain n...

As Dwain has already said, the hard coding method, though tedious is the best for Production and quite readable

I have presented below the code to do it using Dynamic SQL....

I sincerely feel you are wasting time( including yours...

xmozart.ryan (7/23/2012)

---

Kingston Dhasian (7/23/2012)

---

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,...

Do you have any DDL trigger in your database?

If Yes, then check the code and see if it updates any table to which you don't have permission.

What is the datatype of...

You are probably using SQL Server 2000

EXCEPT operator works only in SQL Server 2005+

forsqlserver (7/23/2012)

---

I want to know one thing ..If I am deleting data using join and I want to drop the data on both the tables but only on the first...

In that case, you can use the LEFT OUTER JOIN, as I had suggested earlier

DELETEa

FROMT1580 a

LEFT OUTER JOINT2115 b ON a.C301289100 = b.C1000000161 AND b.C7 < 5

WHEREb.C1000000161 IS NULL

You said...