Oh, I love those words! "Stuffed up"... I've got an Irish friend at work who says they "buggered it up"... if people only know how nasty those words really...

cgnospam (7/12/2008)

---

MVP for the most part is a marketing whore.

There are a lot of companies that do it. They pick pick online "evangelists" on forums and use them to...

Heh... as you well know, it doesn't have to be something new to be abused... look at cursors and While loops... look at people storing dates as formatted Varchars... people...

Heh... if you want a part time job that will really keep your skills sharp, get a copy of the Developer's Edition of SQL Server and answer 10,000+ posts on...

keerthy.vishweshwarachar (7/12/2008)

---

Hi,

This problem arise because we didn't able to read the excel / csv file from ftp location.

From local server I can read excel / csv file using openrowset function.

So,...

Eric Inman (7/11/2008)

---

I would get the fire and sword out and demand another tier do this work. My tier CPU is allocated to set based operations. not gross string sex....

rbarryyoung (7/11/2008)

---

The canonical way to do this is to OR the values to gether and then test the Negative bit (or just test the final result for negative). Unfortunately,...

rbarryyoung (7/11/2008)

---

Hey, I just realized... This is the post that you broke 10,000 on! :w00t:

Woo, hooo! ...

rbarryyoung (7/11/2008)

---

rbarryyoung (7/11/2008)

---

I agree with Lynn.

Using commas is the older, "SQL-89" syntax and it is deprecated...

Skipping all the lectures about the extreme RBAR of recursive CTE's...

A CTE is the same thing as a Subquery in the FROM clause (Derived table) except that it may be...

:blink:

I answered a help wanted ad for...

For a 2 dimensional split, see the following...

http://www.sqlservercentral.com/articles/T-SQL/63003/

The real problem is going to be how to make a table from that... you will need to use the parameters in...

You don't have to...

SET ANSI_WARNINGS OFF

... will eliminate this expected error message.

Just to be sure about a couple of things, you might want to post the proc for a...

I'm in the process of writing a couple of articles on Cross Tabs and Pivots... the more I dig into Pivots, the better I like the ol' classic crosstab. ...