It depends. With 80 users and no anticipated growth, if using SQL Server 2008 Standard Edition I'd purchase it per processor if using either single socket or dual socket...

Lowell (4/8/2010)

---

I'll admit it, I'm weak on inline TVFs; had to look it up;

i've saved a lot of Paul's recent code that was converting other's scalars to inline tvf's but...

I'll start by asking this, define better.

I have not had the opportunity to with Oracle. I have been working with SQL Server since version 6.5. I'd say this,...

Expected to see some comments following this one; has me curious. 😛

Grant Fritchey (4/8/2010)

---

Gianluca Sartori (4/8/2010)

---

WayneS (4/7/2010)

---

As a parent, you always need to be ready to follow through on any threat that you make. And the sooner you do it, the...

Only until...

PaulB-TheOneAndOnly (4/7/2010)

---

Too many questions for a single post - I'll take #4 for $400 😀

DELETE - assuming no predicate in...

CirquedeSQLeil (4/7/2010)

---

Please just stop - everybody. This kind of stuff...

Gift Peddie (4/7/2010)

---

CirquedeSQLeil (4/7/2010)

---

Gift Peddie (4/7/2010)

---

GSquared (4/7/2010)

---

Gift Peddie (4/7/2010)

---

Lynn,

When I say a product comes with limitations I know...

Ninja's_RGR'us (4/7/2010)

---

Lynn Pettis (4/7/2010)

---

It may help to see the whole problem not just a piece of it. Can you put together a test suite including the expected output? ...

It may help to see the whole problem not just a piece of it. Can you put together a test suite including the expected output? I know I...

Just for the heck of it, try this in-line TVF. I'd be interested to know if it works.

ALTER FUNCTION [dbo].[GetSubCategoriaComprador] ()

RETURNS TABLE

WITH SCHEMABINDING

AS RETURN

WITH cteSubCategoria as...

CirquedeSQLeil (4/7/2010)

---

Pranav Shah-410191 (4/7/2010)

---

There are features.

There is also BOL.

There are also tons of web-sites, books, etc.

But then there is something more valuable EXPERIENCE.

So, I thank you all for sharing your...

CirquedeSQLeil (4/7/2010)

---

Lynn Pettis (4/7/2010)

---

Some times the Saints just have to knock a few heads....

Some times the Saints just have to knock a few heads. 😉