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...

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

FORUM POSTING ETIQUETTES - JEFF MODEN

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

Yes and as Jeff pointed out, make sure your path is a shared drive with the account that is going to execute the query have ALL the necessary permissions to...

Hi there... Check if the following code works for you

IMPORTANT : Follow the comments in the code block and customize it with appropriate values for your needs...

--Performance improver.

SET NOCOUNT ON

--Local...