You can not insert data into 2 tables simultaneously in a single session.

But if u split the insert statements into 2 statements, it is going to give you the...

Wat were u trying to do actually?? is there a question here?

For starters, here is a sample code

IF OBJECT_ID('TempDB..#Temp') IS NOT NULL

DROP TABLE #Temp;

CREATE TABLE #Temp

(

UserName VARCHAR(10),

EventDt DATETIME,

filDate DATETIME

)

INSERT INTO #Temp

...

Read about ROW_NUMBER here : ROW_NUMBER .. This is exactly what you need!

Dear Siva,

No one is picking on you. All tehy say, you MUST consider speed and efficiency of the application(or code) while designing or suggesting

Here is the set-up on a million...

You may want to read about Triggers which do exactly what you wanted!

Link : DML Triggers

Gail is a HER , not a HIS 😀

Gail Shaw is one of the MVPs of SQL Server and the best I have seen...

Going by your logic, shouldnt row 2 be deleted also?

Is this it?

SELECT Description, SUM(Balance)

FROm Table

GROUP BY Description

R.P.Rozema (3/4/2012)

---

ColdCoffee (3/2/2012)

---

This?

SELECT OutTab.TABLE_NAME,

STUFF ( (

SELECT ', '+InTab.COLUMN_NAME

...

Wats your expected result from that sample table?

This?

SELECT OutTab.TABLE_NAME,

STUFF ( (

SELECT ', '+InTab.COLUMN_NAME

...

Look at taht.. Reply in 25 mins.. thats what provide sample data and tables will do!

Similar to Rory's , but doenst require a ROW_NUMBER

SELECT OutTab.title ,OutTab.[subtitle] ,

Cities =

...

SQLHeap (3/2/2012)

---

I've been beating my head against the wall trying to figure this out:crazy:.

Select tablename, col1, col2, col3, etc. on just 1 row and dynamically. In this...