I tried that option too

Yes I did

ROW_NUMBER() OVER( PARTITION BY DATEPART(yy,date),DATEPART(mm,date) ORDER BY DATEPART(yy,date),DATEPART(mm,date))

but that's not giving me desire result

thanks but this want solve mu issue

date cane be different for smae month something like

Rn ColDate

1 2010-02-01 00:00:00.000

2 2010-02-03 00:00:00.000

3 2010-02-05 00:00:00.000

4 2010-02-10 00:00:00.000

5 2010-02-12 00:00:00.000

1 2010-03-01 00:00:00.000

2 2010-03-11 00:00:00.000

3...

yes but how about dates

yes for that I want to check what going on may be you idea is batter to sat som impossible value as default then NULL

but their is no way of...

Lets say I have default value as 1 then what??

Yes I knoe it will use Null if value not passed in

but is their a way to chack at run time to see it's uses default value or passed in...

Thanks

this works well

Thanks

but i am looking for an easy way to insert records in this table so wont miss any combination

I have to insert records for all combinations

user will pass me tmpTable with following valuse

INSERT MATRIX

VALUES(2,3,1,2)

-- this is swith x y cordinate

-- In table we have inserted record like this (1,2,2,3,1)

INSERT MATRIX

VALUES(1,1,2,2)

-- In table...

CREATE TABLE MATRIX(

ItemA1 INT,

ItemB1 INT,

ItemA2 INT,

ItemB2 INT,

Point Int

)

INSERT MATRIX

VALUES(1,1,1,2,1)

INSERT MATRIX

VALUES(1,2,2,3,1)

INSERT MATRIX

VALUES(1,1,2,2,1)

ITEMA + ITEMB represent 1 axis in the matrix and combination of all 4 should be unique

and...

Thanks For prompt reply

Thanks for reply

Looks like batter solution

also one more question

how can we maintain refrential intrigtity between common data to use in my production data

Thanks

Let me explain scnerio

we have a 10 prod servers with having single prod database having common schma

in all databases we have a common data of roughly 20 GB

what I wants...

No Just one INT column and will mask it to 26 flages