Hi skc,

Thanks, I've copied the desired output of my records above in the post. As per the query, It will give me all the records for a particular

Tid except...

My Query:

---------------

Select tid, transtype, amt

from GLTbl a

Left outer join DetTblt b on a.transtype=b.transtype

where tid=12345

And transtype not in (Select transtype from gltbl where transtype in('debit','credit')

Group by transtype

Having SUM(Amt)=0)

Order by tid,transtype

The result should be like:

Id Type Amt

-----------------

101 Cash 100

-- 101 Credit -100

101 Expense 200

-- 101 Debit 100

101 Expense 200

102 Cash 200

102 Credit -50

102 Debit 100

--------------

Could you provide me How...

Thanks Dave, I tried but didnot work. Even I tried using Row_Number clause but no luck.

In my SP, I'm trying to delete the No. of rows on the basis of some conditions.

So, that query is acting as recurssive. Is there a way to change that...

IN SQL-2000

To disable / enable selective triggers...

ALTER TABLE tableName DISABLE TRIGGER triggername

ALTER TABLE tableName ENABLE TRIGGER triggername

To disable / enable all triggers...

ALTER TABLE tableName DISABLE TRIGGER ALL

ALTER TABLE tableName ENABLE...

I tested this & not satisfied the answer. Please provide with an valid example.

Hi Brandie

Little doubt, as Functions execute once per row, so How the UDF runs only once in From Clause.

When you do 'restore database --> From Device --> File; click the 'ADD' Button-->

Get the FULL UNC path as "\\ComputerName\Shared folder\Backup\abc.Bak" by mapping in the

explore window.

Copy the path &...