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

And Mr.adarsh.u.tholar.b , never put your new request in form of reply to an ongoing thread, open a new thread and place forth your new request. There by many...

adarsh.u.tholar.b (4/8/2010)

---

Hii

In converting a Single Row to a columns:

In my case the row is consisting of gmail id's separated by commas ie aa@gmail.com,bb@gmail.com,cc@gmail.com

I wanted the SQL Query where the colums...

adrian.sudirgo (4/8/2010)

---

Hmm.. not really. Actually I'm looking for the capability so that when 2 or more results came in simultaneously, they will not be matched to a single request (with...