In T-SQL you'd simply use a CASE satement in your INSERT/Update statements, something like

CASE WHEN LEFT(...

support 86837 (12/18/2012)

---

I have two tables, one for Orders and then an Assiged Parcels table which can have multiple records attached to an Order. In the Order table is column...

sql1411 (12/18/2012)

---

Yes members can be reactivated. However, this reactivated members would be treated as a new members and we would only use the points they've earned after they've reactivated again....

What are you using for the data load? Bulk Import? SSIS? SCD T-SQL script off a staging table?

Just a few clarifications, if I understand this right.

In the pts columns, for the final item, shouldn't pts1 be 0 and Pts2 be -1100 to zero the account off?

Can a...

Oh, such fun, lot rezonings. Used to work in land appraising. Brings back memories. ... errr... I'm digressing.

My apologies for the initial confusion. I thought you...

GYEAH... nHibernate.

Can you get a hand on your coders to explore the underlying foundation calls? If you can, they can probably get you a better idea of what that...

Export the package to a dtsx file and get it into BIDS/VisStudio. You need to see what the problem is. Usually it's a schema modification screwing up metadata...

Does it have a rss stream or are you scraping the data off the page? What format are you getting it in?

Usually sites like that have the ability to...

What are you intending to do with the resultant #temptable? The syntax issue you're running into is:

SELECT whatever INTO #table FROM tablexyz.

Alternatively CREATE TABLE #table INSERT INTO...

2 hours? What books...

Usually you'd use an audit and/or logging table to move deletions over. SCDs can't autodetect removed information. Trigger your deletions to an audit table and create a separate...

Oh lord, that.

Alright, yes. You can use SSIS as a data source for a Report. It's like...

Fal (12/12/2012)

---

Sure. I got this from a place called The Internet:

"This refers to how intense romantic scenes are in a story and how intense the sexual tension is between...

+1 Chris. Another option is to not store the connection information in the package and set it up as a configuration, so if it ever changes you merely need...