We have triggers on certain tables that kick of a real time integration between our systems. For Example, when a Customer's Name is changed in one database and we...

Thanks for the clarification! Where I work, one place where a MERGE Statement I think would really work is within a Trigger, have any of you used a MERGE...

Thank You Gail, this worked for concatenating two of the columns. I am now going to work on concatenating the 4 together.

Thanks Again.

I agree that what I presented does not need to be Dynamic SQL, BUT this is to be a part of much larger query where Dynamic SQL is needed. ...

I give up to easily sometimes...

Using CAST(myval AS DECIMAL)/100 is giving me what I need.

Thanks

Thanks Koen for the reply...do you have a URL's with this information in it?

Thanks Again...

Hey Daniel, Thanks alot for the reply. I am going to attempt to implement your first suggestion as I do not have that many header columns.

Let's hope it goes...

You are 100% correct, I should of known that.

Thanks

Thanks for the reply, I ended up getting it with this:

SELECT (2670*(1-(convert(decimal(18,2),30)/100)))

Thanks Again.

I got it figured out, in case anyone has the same issue, this is what I did:

@var =="1" ? "A1" : (@var == "2" ? "B2" : @var == "3"...

It is a brand new package and when I added the third Execute Package Task, I pulled one over from the toolbox and set everything up (I did not copy...

Thanks Bob, that works. If anyone else has a different way to do this, I would like to see it.

Thanks everyone for the help....I choose the Database Developer path. This could end up being a BI Developer or could lead back to a DBA type path.

Which path, DBA or DB Dev, has the best outlook over the years come? I agree, with the DBA Dev translate to the BI Dev easier. BI stuff...

I agree with you...we are a growing company and it is in the plans to continue to grow both organically and by acquisitions. So they feel that it is in...