Calculated column = Derived column. I'm too used to what they're called in the database, gave you the wrong name. Sorry about that.

You should be able to add...

Jeff Moden (7/17/2009)

---

mmunson (7/16/2009)

---

Hi GSquared! 🙂

I could.... but I was hoping to get around that because I would need approval to create a new table. And...

It's gotta be something on that workstation, in that case. Not sure what it would be, but it might just be a matter of backing up local user files,...

Define what you mean by "between". I don't see anything in the table that indicates the row sequence. Is there supposed to be an identity value or a...

If the column is defined as an identity, there are other steps you'll have to take, since you won't be able to just update it. Is it?

Will you need to copy views more than once?

If so, it's possible to set something up to look at object definitions and then execute those in the target database. ...

I searched for "SMS .NET" in Bing, and this was one of the first results:

http://www.codeproject.com/KB/IP/Sending_SMS_using_Net.aspx

Will that do what you need?

You can run SSIS packages from Dev Studio, or you can schedule them in jobs, or you can run them from the command line. It depends on what you...

Are you familiar with Max() and Group By?

Mentioning my SSC participation on my resume got me an interview a while back. Definitely helped. (My asking price was more than they could afford, so I didn't...

If you save it, it's an SSIS package, just like any other. You'd run it the way you'd run any SSIS package.

If you save it to SQL Server, you...

Create a calculated column in the Data Flow task in your SSIS package, build the conversion in there, and use that column instead of the original data.

Does that help?

Any reason you can't create a lookup table and join to that? One column with the abbreviation, one with the friendly description.

Something that might save you a bunch of work, and clarify a few things at the same time: Open up the Import wizard in Management Studio, set up the import...

I'm kind of guessing here, but is it possible there's a mix-up in the UserIDs in the system tables?