I got this to work somewhat..

All this while I was executing a single task but I debugged my package now and it started logging into the text file and...

yes...

thanks d_sysuk for that using rank and over.. that works beautifully!

i work with 2005 so just need to bother with that for now...

sol (7/16/2008)

---

Personaly, I don't think use "like" is a good idea.

Because user can input "%" or "*" in their input string and so, your condition will fail to compare...

San, do you have any more information regarding this puzzle? For instance, are you aiming to change an existing table to meet your criteria, or to return a satisfactory result...

I too think 'Like' is the best solution as suggested above.

Jeff Moden (7/15/2008)

---

Heh... you guys are missing the real problem! 😉 The real problem is why does the OP NOT care about which data is returned? If you...

Thanks min max functions are an easy way to do it

Yes absolutely.

Thanks to both of you!

Thanks!

Well we have found another way to do the same without OVER

select * from testtable

select distinct id, (select top 1 datavalue from testtable where id = t1.id) from testtable t1

Thanks for the replies!

It worked.

Is there any way to do this without the OVER clause?

Also can you also suggest me a good article on the window aggregate functions. The OVER...