anthony.green (5/17/2012)

---

This will point you in the right direction if you dont have the traceflags enabled on your instances

http://msdn.microsoft.com/en-us/library/ms186385.aspx

Will need to refactor the job to send the mail, or get...

I was trying to Execute a Stored Procedure from inside a Function. This was not actually a Business Requirement. Just for learning purposes and to...

No, Preetham.

It doesn't work. It will just return the value of @res which in this case is "(Select * From OpenQuery(ABHI, @tmp))". It won't execute the Open Query. I actually...

anthony.green (5/17/2012)

---

This will point you in the right direction if you dont have the traceflags enabled on your instances

http://msdn.microsoft.com/en-us/library/ms186385.aspx

Will need to refactor the job to send the mail, or get...

Thanks Loundy.

I'll give that a shot. 🙂

Thanks for the reply Joe.

Yes, that was the problem. I was behind a Proxy which was blocking outbound SMTP.

I finally got it working.

I have another small question. Can I configure...

Doesn't Gmail SMTP work??....If I am behind a Proxy...I might need...

Yes, Anthony. You are right.

Just a few days back someone(a developer) was telling me that one can be a good developer if and only if he feels "the excitement" in...

That's a very nice solution by Anthony. 🙂

But, if you are not comfortable with PIVOT then you can use a simple CASE Statement like this:

--Declaring Temporary Table

declare @tab table (product...

Different people may have different point of Views on this. But, from what I know:

An AD-HOC Query is a query which is created on the fly, for a specific Non-Generalizable...

You're Welcome. I'm glad it helped You. 🙂

Eugene Elutin (5/14/2012)

---

vinu512 (5/14/2012)

---

Phil Parkin (5/14/2012)

---

vinu512 (5/14/2012)

---

tbabs25 (5/14/2012)

---

Can anyone help me in coverting the output I am geting when a type in my select statement.

I get a number in return...

Phil Parkin (5/14/2012)

---

vinu512 (5/14/2012)

---

tbabs25 (5/14/2012)

---

Can anyone help me in coverting the output I am geting when a type in my select statement.

I get a number in return instead of data.

select...

Following links might be useful to you:

1. Calculating Quartile in SQL Server

2. Inter Quartile Range

If you manage to find out the NTile using the first link then IQR is going...

Error 50000 is a user-defined error.

Look for the "RAISERROR()" and check what the code is around that and the conditions that will cause the error to fire.