Vaibhav, can you give us some sample output rows inline with your sample data u have provided.. some visual representation of how your desired result set must be...

Hey padmaja,

how about you going through this following article and helping us help you?? 🙂

FORUM POSTING ETIQUETTES - JEFF MODEN[/url]

When u do so, i am sure a lot of us...

Hey buddy, here is one piece of code.

I think Lowell and steveb. let out one tiny thing in your request , that is, to add the part of the string...

WayneS (4/9/2010)

---

Nuts, do you see how things work better when you supply code that shows the problem? A lot of people that wouldn't bother with your problem suddenly jump in...

xp_Dirtree , an extended stored procedure looks like a very good option to check for the files and folder in directory. 🙂

I think nguyennd has got the code you wanted...

Cheers!!

Nuts, u made us (rather, me) 70 % clear 😀

Now, on what basis should we rank the results? TotalCost ??

Like, the test that cost the highest in a particular quarter...

Jeff Moden (4/8/2010)

---

COldCoffee (4/8/2010)

---

No issues Jeff... i am infact...

I second Wayne here... please post as

1. Create table scripts for your table.

2. insert into table scritps - some sample data that will look like your actual data

3. indexes/constraints on...

Mate here is one way of doing it...

i recommend u reading thro the post by Jeff Moden on how efficiently u can do it

http://www.sqlservercentral.com/Forums/Topic899000-338-1.aspx#bm900104

-- Create the table

if object_id('Duplicates') is...

Glad it helped you buddy 🙂

Cheers!!

Mate, did u test my code? din't it work for you?

No issues Jeff... i am infact feeling great to...

Glad it helped you mate!! 😉

Cheers!!

Hi buddy, please post your code that sends out the database mail.. Without seeing your code how can we guess what the loop-hole is??

Go thro this following post to...