Thanks, it is good to know.

I am changing some one else code, so need to be careful

Thanks

I do need the streetname there.

Actually more columns are existing, I make it simpler and just said prefix+ streetname +suffix.

Actually we have houseModifier + prefix+ streetname+ suffix as an...

Thanks, I do see there is a number 1011.

Shall I change it to (5,1)

Thanks

mayurkb (6/17/2013)

---

There are couple of options:

1. Do you use actual street name anywhere else. Or else you can insert the street name with prefix and suffix. This would be the...

Thanks, that is what I meant to udpate a column and in joins and cross apply use the inline table function.

Thanks, the two answers is just what I want.

One more question, so for join inline table function we should always use cross apply, is that correct?

we can also use table...

Thanks, this is what I want for to get a group of student's street.

Then how can I get for the single student street by join other table, I tried this:

DECLARE...

so here is what I plan to do now:

1. create a Execute SQL task using OLEDB connection ( source SQL server) with select query and full result set.

Set the result...

Sure. Your package would have a Data Flow containing an OLE DB Source and a Recordset Destination (really it is an ADO.NET DataSet under the covers) to capture the employeeID...

I will.

Yes, I think what we have created two instances on node 1, one is for pro, th other is for qa, then we added the same two instances on...

Forgot to mention MOSS 2007 is at sp2

Sorry, it is a red down error, I didn't see it clearly.

Is it safe I click show the critical events for this cluster node?

There are two nodes name there:

one is CS1 and the other is CS2, CS1 is active, and CS2 has a red dot next to it, so means passive.

But I see it is grayed out.