Eugene Elutin (9/19/2012)

---

You wouldn't...

I would use @@VERSION for that, because you can get the SQL version year, and then it's more self-evident about what you're checking:

DECLARE @isSqlServer2008 bit

SET @isSqlServer2008 = CASE WHEN...

Definitely don't use a cursor.

But you could pass all the values at once as a table-valued parameter; you just need to modify the code of the sp to handle a...

Lowell (9/18/2012)

---

i just tripped over this exact lack of planning by the database architect when switching from one insurance agency to another. From Geico to Progressive: I saved 30% or...

Eugene Elutin (9/17/2012)

---

GSquared (9/17/2012)

---

Eugene Elutin (9/17/2012)

---

And you didn't respond to the basic assertion about e-mail, which is its horrible weakness as a primary key for human beings. I...

Do yahoo and other email provides allow expired and reclaimed email addresses to be re-cycled?

If any of them did recycle one, and I got the same email address as a...

CELKO (9/17/2012)

Think of a parking garage (disk) and parking slot numbers (identity, rowid, or other physical locator). The slot number does not appear on your insurance from, at the DMV,...

Luis Cazares (9/17/2012)

---

I came out with the same code as Jeff showed in the article, but I believe that Scott's code would be better as it is a single table...

SELECT

CustId

FROM dbo.product_details

GROUP BY

CustId

HAVING

MAX(CASE WHEN ProdId = 0 THEN 1 ELSE 0 END) = 0 AND

...

GSquared (9/17/2012)

FROM (

SELECT CAST(CAST(@year * 10000 + 0101 AS char(8)) AS datetime) AS month_start UNION ALL

SELECT CAST(@year * 10000 + 0201 AS...

CELKO (9/17/2012)

Wikipedia says that as of 2011, more than 2.2 billion people – nearly a third of Earth's population — have email. I seldom work with a target audience...

Lynn Pettis (9/17/2012)

---

I still doubt that ecommerce sites use your email address as a primary key. This is a volitale attribute subject to change, and isn't one I would...

I'll assume you want to count them separately. If you want a total...

DECLARE @year int

SET @year = 2012 --<<-- chg as needed

SELECT

month_start,

--'19000106' is a Saturday, so DATEDIFFs below count Saturdays:

...

GSquared (9/17/2012)

---

ScottPletcher (9/14/2012)

---

Code below has fewer calcs and does not depend on any SQL date settings.

DECLARE @year int

SET @year = 2012 --<<-- chg as needed

SELECT

month_start,

...