I was amused by what I assume is a typo in the last paragraph

...but show that they value customers enough to now squeeze every last dollar out of their budgets....

Depending on what you want to do, how about Perl? (Try http://www.activestate.com/Products/activeperl/

You can either create your own format or use it's POD format.

For example:

create procedure userproc

as

/*

=head1 xproc

=head2 Parameters

None

=head2 Description

This selects...

For most of what I need I use SMALLDATETIME and await the opportunity to use 2K8's DATE type!

The only...

That's what I felt when I wasn't getting...

Pete Brown (12/13/2007)

---

I wonder what benefit questions like these have to the community at large.

I thought the question of the day was there to inform not just to make the...

Sagesh (12/13/2007)

---

Thanks for the valuable information.

I checked the Query like this :

"SELECT * FROM dbo.Customers AS C

MIDDLE JOIN dbo.Employees E ON C.CustomerID = E.EmployeeID",so it's showing some error.If i...

Jim Russell (12/13/2007)

---

As I'm sure you know, all SQL Server Objects support extended properties; I try (with only modest success) to define and populate a "description" property (and others as...

Sneaky.

Reminds me of the advice when reading program code (any language) ...

"Don't trust the comments (or formatting?). Read the code!"

Sagesh (12/13/2007)

---

I tried this query in SQL SERVER 2005,It's giving some...

Actually I wouldn't expect...

I skimmed the information of these sites and there is a lot of interesting information. Unfortunately, although there are discussions about how the optimiser uses statistics to choose...

Please post what you've tried and, if I have time, I'll see where you are going wrong if I have time. Like most people here, I don't get paid for...

My question really relates to why the optimiser is so poor and identifying temporary results which could be calculated in advance.

I'd always been told that with (quotes)"set-based programming"(end-quotes) one should...

My immediate reaction was "Interesting, but where's the hint as to how to avoid/mitigate the problem?". I have a real-world case that suffers from poor performance and this has pointed...

Just something of an aside really...

Microsoft recommend that people don't name stored procedures sp_anything. See http://msdn2.microsoft.com/en-us/library/ms190669.aspx#sectiontoggle0.

Apparently the search algorithm looks for sp_anything as a system procedure first. Qualifying it doesn't...