I couldn't...

Jeff, your response is valuable to the original poster in that it gives him a straight-forward, scalable solution, but may be more valuable to me and others on SSC in...

I don't even have 2008 yet, but am trying to get ready for when we get it. We have many datetime fields currently used for just a date, letting the...

If you're just trying to compress the code, you may want to consider a user-defined function that takes NO_Mnths, BTG and the integer month number as input and returns the...

The only difference between PATINDEX and CHARINDEX is that PATINDEX supports wildcard characters for the match whereas CHARINDEX does not.

This code uses Charindex to fill in parameters of SUBSTRING....

GSquared (6/5/2009)

---

Jeff Moden (6/5/2009)

---

Gianluca Sartori (6/5/2009)

---

I won't blame Jeff if some day it stops working, I will just restore the old procedure and tell the users they have to wait...

DBA Cabuloso (6/5/2009)

---

The question is about the space allocated to a variable like

DECLARE @onechar as varchar(1)

DECLARE @onechar as char(1)

not to a table.

And the space allocated to both is equal.

Pay attention...

Alvin Ramard (6/5/2009)

---

cs_troyk (6/5/2009)

---

Actually, varchar(1) is the "best" choice from the standpoint that when people blindly follow advice like this without doing their research, the resulting system will be rife...

A quick look at BOL explains the at-first weird looking addition result in your second example. FLOAT datatype defaults to 53 bits of mantissa data (the maximum for the...

Jeff Moden (6/3/2009)

---

WayneS (6/3/2009)

---

SQL Server Magazine just published an article by Itzik Ben-Gan where under certain conditions, a cursor-based approach scales out better than a set based one. I'm curious...

My goodness, what a teaser of an "Executive Summary" and first three sentences of the article. It sounds as though...

Steve Jones - Editor (6/2/2009)

---

I have added a note in the article that the discussion should be checked. And I've logged an enhancement to automatically add notes to content when...

Adam Machanic (6/2/2009)

---

. . . . . . People believe, rightly or wrongly, that...

mahesh_7474 (6/1/2009)

---

Hello gurus,

I am very new to SQL Server. I have attended the intreview for SQL server Junior developer. I can not find the answers for some of the questions...

Jeff Moden (6/1/2009)

---

Lynn Pettis (6/1/2009)

---

Grant Fritchey (6/1/2009)

---

Lynn Pettis (6/1/2009)

---

Great. I guess I can read them because their my articles, becuase I sure as heck didn't pay for a membership....