Thanks A Lot.

:-)It Helped me A Lot.:-)

I am facing the below error:-

Cannot perform an aggregate function on an expression containing an aggregate or a subquery.

The Complete Query is as follows:-

SELECT

TEJPGLMA_LEAF.GL_CODE,

...

You Can Use this Way of Insertion into a Temporary Table

SELECT [the SUM] = (DATEDIFF(minute, t1.[time], t2.[time])) into #p

FROM

(

SELECT [time], row = row_number() OVER (ORDER BY [time])

FROM @TABLE

) t1

INNER JOIN

(

SELECT...

Hi Orakid,

We can maintain multiple sessions in SSMS using Dynamic Management View (DMV).

By using this keyword u can see how many sessions are opened sys.dm_exec_sessions

For further reference, u can go...

What does that command do Mr. Jannie?

Let me know clearly?

Hi Friends,

Thanks for your Replies..

I don't have permissions to take backup of a database...

In this Case, How do I take a backup of a table?

I don't want to take whole...

Thanks A Lot Tim 🙂

hi,

As I look into the Output Clause,

While we use insert command

then the Temp table i.e @tab

should be shown only the inserted values only right?But now the output...