Matt Miller (9/18/2008)

---

It makes sure that the trailing spaces don't get truncated before you count them. (LEN will not count trailing spaces). by adding it to both - it...

Yes! Fatfingered it again!

Adam Bean (9/18/2008)

---

Terri (9/18/2008)

---

Replace the CASE statement with:

([ROWNUMBER]/2 + 1 ) AS [Team]

from BOL

If an integer dividend is divided by an integer divisor, the result is an integer that has...

Replace the CASE statement with:

([ROWNUMBER]/2 + 1 ) AS [Team]

from BOL

If an integer dividend is divided by an integer divisor, the result is an integer that has any fractional part...

Where I live (New Orleans) Executive MBA programs can cost twice as much as traditional MBA programs. At UNO the EMBA is $28,000 whereas the MBA is $3600...

Steve,

How do I start a new thread? I have only posted replies.

My office wants us to start telecommuting several days a week because they want to hire more workers but don't have enough office space. Most managers want their team...

We include CreateDate, CreatedBy, UpdateDate and UpdateBy columns on our tables which are updated in our update triggers. We also log the record to an audit table...

In the wake of Hurricane Katrina my organization issued Blackberries to all of the IT staff deemed critical. the specific features they wanted was QWERTY keyboard and push-to-talk. ...

Lester Policarpio (1/21/2008)

---

correct me if im wrong if you are running this query:

INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\Test.xls', 'SELECT * FROM [Sheet1$]')

SELECT * FROM Table1

it means that you need to create...

And my calculator says it is an error:exclamation:

Shaun McGuile (1/3/2008)

---

Jeff: Gis a Job then mate!:)

ROFL! I would shoot these people before they could damage the ecconomy! I might not be able to spell but maths like that...

paul.alan.taylor (10/23/2007)

---

...

It's probably worth pointing out that I've been asked for my degree precisely twice in my career. If companies truly prize the acquisition of a degree, you'd think...

I have a BS, MS and PhD in Mathematics. I taught math and computer science at the university level before becoming a developer.

Our shop requires a BS...

Template Explorer is improved and easier to use in SSMS than in QA. We have switched to SSMS because of the integration with SourceSafe