When you tend to only draw hard, fast lines...

Perry Whittle (9/6/2010)

---

incidentally Wayne, although i do sort of agree with Jeff and Lynn,

"all pirates should find their own treasure"

i do think that you presented well to the OP....

No where clause.

No index on the columns being joined.

No index on the columns in the where clause (just in case you didn't specify it in your post).

Using functions on columns...

niall.baird (9/5/2010)

---

Being possibly the only person in the universe that doesn't have a twitter account, a facebook page, a myspace page or anything else like that (other than a linkedin...

As Jeffrey already said:

Jeffrey Williams-493691 (9/6/2010)

---

mak101 (9/6/2010)

---

How can I open...

Johnnymac (9/6/2010)

---

awesome, thanks wayne, that did the trick. I was able to add a few more columns I wanted to show in the report, its prompting for the start...

Open up BIDS. Start a new SSIS...

On that same screen (Column Mappings) is a check box for "Enable Identity Insert"....

Also, if you have a two-node cluster with the nodes really close together, you can use a network cross-over cable.

Everything that I've read about clustering says that the private heartbeat should be on it's own network gear, separate subnet, etc. Essentially, try to keep it off of the main...

On the Import Wizard, when you get to the screen where you select the Source Tables and Views, select the tables you want to copy FROM. Then, click the "Edit...

If your "holiday" is anything like mine, then you need...

Good point Perry.

Without having the table ddl, I'm guessing here, but this looks like it would work:

SELECT account0.name as 'name',

ab.createdon as 'orderdate'

FROM FilteredAccount...

Lynn Pettis (9/5/2010)

---

Jeff Moden (9/5/2010)

---

Sooooo... now that we've taught someone how to accomplish SQL Injection, I have to ask... will he use it to avoid injection or carry out revenge...