Just to check with you..

Is the index order is a per column selectivity?..at times it does make a difference....

Hi Chris

/*

why do you think it should be allowed?

If the two columns store the possible combinations of fruit that are sold in a bag, then the order surely doesn't...

Chris,

The buisness requirement is

n1,n2 shd be unique even when interchanged.

unique constraint on 2 columns shd work even when values are interchged.

n1 n2

11 10 ->allowed.

10 11 -> fail...

One more solution..

Copyrights to my collegue sitting in next desk.. 🙂

create table t3(

n1 int not null,

...

CREATE TABLE [dbo].[t3] (

[n1] [int] not null,

[n2] [int] not null,

[n3] as n1 + n2 ,

[n4] as n1 * n2

CONSTRAINT [t3_unique_key] unique (n3,n4)

)...

One close to ideal solution is

> use foriegn key constraint on the transaction table to avoid deletes on the master table.

> In case if want to repopulate master table( after...

DBCC FREEPROCCACHE

DBCC DROPCLEANBUFFERS

/************************/

To Verify whether it has done the job..

DBCC PROCCACHE

The values displayed will be in single digits ( if only the current user is connected ).

Please handle with care...

This is the sp i use to get the permissions for a particular obj..

I guess you modify it as per your needs..

CREATE PROCEDURE sp_get_permissions (@str_obj_name varchar(300) = null)

as

BEGIN

select '...

are u using sp_executesql/exec/print..?

may be if possible ask ur front end or pgming guys to pass it to ur sp as parameter..

thats wat i did last time..but lemme give it some more thght

@ Christopher,

exec takes the param nvarhcar which can have max 4000.

So no matter how many '+' u do if ur total is gretaer than 4000 it doesnt work..

most likely u r running out of size. ie 150 lines of code wouldnt fit into 500 nvarchars..

so u must use a datatype like text or smthng and if u...

The problem discussed on this topic is different from what you have explained.

And btw, Why you need to use a cursor when you can do this with a query 😉

Ansii Nulls..hmmm..I dont know the tone of your comment ( Sarcasm ? )

but i felt there is a remote possiblity of Ansii Null affecting this one.

If Anscii nulls...

err..i missed the other part of join eh..

this one works i suppose

delete x from

( select row_number() OVER (order by getdate()) as id,col1,col2 from #t1 ) x,

( select row_number()...