It seems that what you're being given to import is the value without a decimal point. Since you're talking about using a select case, how does dividing that number by...

Steve Jones - Editor (6/8/2009)

---

In my presentation this past weekend in Florida, someone asked if I thought recruiters or HR people would look over forum postings when considering a candidate...

Hey Barry... how many more articles do you have planned for your "15 ways to lose your cursor" series, and when would the next one be publishing? It's been too...

Use the STR function with the proper...

Hi there,

It's been a year since I did this, so I don't remember the exact steps, but you can set up the multi-value checkbox to set the default items to...

Profiler.

see this link.

Yeah, but it appears that he at least read it over some. I...

I have noticed on my Vista computer that when I want to attach a database, that I need to run SSMS as administrator (right-click on SSMS, select Run As Administrator)....

siboyd07, I guess the main thing to mention here is that in order to include the column headings, you are going to have to change the way you are running...

Duplicate post.

Please post all responses here.

Thanks, I fixed it.

I came up with a way to accomplish this:

CREATE PROC dbo.BCPOUT AS

declare @header varchar(max),

@details varchar(max),

...

Paul White (6/6/2009)

---

The entry in BOL has always been badly worded and confusing, at least to me.

It goes on to say: "SQL Server treats n as one of two possible...

You know, it's always those complex T-SQL concepts that trip up so many people.

Good going Gail!

Edit: fixed link

Like Jeff, it's usually reserved to this site. Though simple-talk has some great articles, esp those by Phil Factor.