use "not in" clause for the identity column values...

in where clause..

Cheers!

Sandy.

Humm...Ok.

Yes,

But if you try, you can also achieve, but you have to work a little more.

but As I told Its One line of code and Easy to use and Quicker...

Gail,

Please Give the Answer......

Otherwise it will be reset the row_number value......to "O"

Lolz......:w00t::P:D:cool::hehe:

Cheers!

Sandy.

create table #temp

(

a int,

b int,

c int

)

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

Insert into #temp

select 1,1,1

union all

select 1,2,2

union all

select 1,2,1

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

select * from #temp

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

create table #temp1

(

a1 int,

b1 int,

c1 int

)

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

Insert into #temp1

select 1,1,1

union all

select 1,2,2

union all

select 1,2,3

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

select * from...

Now See here....

e.i: replace In with .... [in/not in/ ] ........

he he he...lolz

It will work for Int as well as...

Piotr,

If it's just three random columns, If Not Then....My Question Starts here??

Got it?

My Solution is very simple...and single line of code..and easy...

Grant,

Today is Truth Day n Explanation Day......hehhehe..lolz;)

Would you like to Explain What you told Now......?:w00t:

Holy cow! You guys posted all that in the time it took me to read the...

Grant,

Then what you wants to say?

I mean Do you have any other Idea?

Please tell me then?

I have used a quick Idea to perform this...

Cheers!

Sandy.

ROW_Number is a built-in ranking function that's new in SQL 2005.

the order by clause in it specifies which column or columns define the order for the row number

The partition...

gail, Its your turn Now....:hehe::cool::w00t:;):P:D:)

hehehehehehe.................lolz

Cheers!

Sandy.

Gail,

I knew it,

I just gave one Example for you,

As for SQL, GETDATE() is a Predefined Function some where the functionally...

Hi Johann,

There is a concept called Crosstab query Which will help you a lot for this situation.

Can you please check this with Crosstab query?

Cheers!

Sandy.

gail,

Client does not mean that it will run on the client side,...

hey Johann,

Microsoft Is designed While loop in such a way that you can use IF condition with in the loop itself.

I mean to say that your all condition can be...