Koen Verbeeck (9/3/2014)

---

xsevensinzx (9/3/2014)

---

I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb question just to read the reactions...

What is the error?

Are you sure you have the right syntax?

Select Top 1 Column_Is_an_int = @A_number from ....

Unless I didn't get enough sleep and/or not enough coffee, this is not assigning a value...

Yes you can do it.

When you run the setup, you will be asked if you want to do a new installation or modify and existing one. (I don't remember the...

where (t1.steps + t2.steps) IN (4,7,9) Only works for these values, in this example.

This is my biggest disappointment about SSIS. 🙁

There's no simple way of doing this in the dataflow.

One way I might do this is to create the basic flatfile as you seem to know how to do, without...

What have you done so far to learn how to use the Derived Column Transform?

I've done something like this before, but rum manually via Excel macro.

What I did was query MASTER.sys.Databases.

If I got results, I knew the server was running and the results...

Also check what the Job Activity Monitor is showing for Next Run.

Michael Valentine Jones (8/19/2014)

---

Just some ideas:

Limit the number of forum posts to one or two per day, especially new topics, for a while, say a couple of weeks, after they...

Should be doable, but first I need to know why you're subtracting B2 and subtracting from C2? Why not B3 and C3, or B9 and C9? What ...

Ed Wagner (8/19/2014)

---

SQLRNNR (8/19/2014)

---

Luis Cazares (8/19/2014)

---

Lynn Pettis (8/19/2014)

---

How about this one, starting monthly salary of $4,927 for a Senior Database Developer. That's 2/3 what I made at School District...

Nilssond (8/14/2014)

---

I have a customer history table with the follow structure and data:

CustomerID Tier ...

Erin. (8/14/2014)

---

I'm trying to generate an update statement based off select statement results. A very basic example,

SELECT ListID FROM DListing WHERE Status = 2

Results return 3 rows.

1234

2345

3456

How can I...